Graph Scale - Show only Top 10

[#1]

Hi,

I have an X Axis which shows Root Cause, and an Y Axis Number of Cases with that root cause. The Dimension is Month.

i have around 30 Root Causes, i want the graph to only show the top ten root causes. I know on the Presentation Tab Under Dimension Limitations you can put the maximum visible number as 10. But it just shows the first 10 root causes in alphabetical order. Is there an expression i can put in there to say show the top 10 root causes?

Thanks

Laura

[rajni_batra]

If u r using qlik view 11 then in that we have a new Tab DIMENSION LIMITS... u can add ur condition there to show only Top 10 values.

[#3 · Accepted solution]

Set Y value in 'sort ' to descending. Put 10 in maximum visible under Dimensions in Presentation.