Measure to isolate specific field

Hi Creative_tree88 ,

I have added a few more measures and added a new calendar that includes weeks. see attached

richbenmintz - thanks for this, really helpful indeed!  I am still really struggling to be able to visualise and 'pick out' the 'AD_Modality which has increased the most, over a month or week basis.  How can this be achieved?

Hi Creative_tree88 ,

Try using the conditional formatting option

richbenmintz - I don't know how to do that, unfortunately, and relate it to 'AD_Modality'.  Every time I bring AD_Modality into the table, it goes blank so getting confused as to how this is done, given the tables you've done, relate specifically to month and week dates, not AD_Modality fields...bit flummoxed to be honest.  If you had time, I'd really appreciate if you could show me a visual, based on your month change table, which highlights which AD_Modality has increased the most from this month to last month...?  I think once I know how to do this, the rest should be more straight forward.  Kind regards

Hi Creative_tree88 ,

I have created a rank measure which I used to apply conditional formatting of a measure value, see below

you find conditional formatting in the values area, drop down of value.

modified pbix attached

richbenmintz - many thanks for your help with this, having used Qlikview for so long it's difficult to know where everything is and the subtle differences can actually be quite large when you come to use them!  Really appreciate your time with this - I'll study this sample file and hopefully get to grips with it all.  If I have any problems, is it OK to call on you?  Kind regards

richbenmintz
I've created some tables, based on this formatting and works well.  However, I'd like to try and take this a step further by creating some sort of text box with the highest month-on-month change in numbers (not %) - current full month to previous month would be ideal as looking for peaks / stresses in terms of spiking demand within our business.  Rather than sifting through lots of tables and clicking, how can I create more of a headline dashboard text box type thing which basically says 'MRI has increased the most this month - x vs y last month'...?  I can then re-create this for the specialty and exam fields (which are not included in the sample data, but which I can do myself, once I know how to do it for AD_Modality in the same data I linked for you.  

Once I can see which areas have spiked the most, in numbers terms, month on month, it will allow me to focus in on this specific area, without trying to find it manually by clicking on the table to find it.  These tables are fantastic, but a headline text box telling me exactly where the month on month demand growth is (current to previous month) is perfect.  

I've got this so far, but all it does really is show me the highest change per month overall, not on a 'current month to previous month' basis...?

Really hope you can help!  Rgds

richbenmintz - is there any chance you could help me with this current problem, regarding creating a 'card' on the report which tells users which modality (AD_Modality) has increased the most, based on current to previous month change?  Kind regards

Hi Creative_tree88 ,

Will try to have a look today 

richbenmintz - thank you so much.  Really appreciate it.  Kind regards

richbenmintz - that solution works really well!  Many thanks indeed.  I guess I can tailor it to show fields other than modality i.e. Specialty, Exam etc etc....just by tweaking the script?  Very much appreciate all your help.  Kind regards