Discussion board where members can get started with QlikView.
I'm having two dimensions Vehicle Make and Vehicle Model.
I need to show top 20 vehicle make in pivot table along with the model.
Vehicle Make Vehicle Model
Ashok Leyland Ashok Leyland
Like above example based on loss ratio i need to show top 20 vehicle make in pivot table.How can we write rank expression for this.
I tried as like
I need to show Vehicle model also in the dimension as above example
Please anyone suggest me.
There could be two ways for you to resolve the issue. Either by using Dimension Limit or an expression that returns NULL on the undesired rows. Suppress Zero-Values will hide the NULL values rows.
Thank you for reply. sorry, It won't reaches my requirement. I'm having another ten expressions need to include in the pivot table.Please find the sample app. In this app i'm showing all the values.Need to filter only top 20.