Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
krishna20
Specialist II
Specialist II

Top 20

Hi Friends,

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.

For Eg;

Vehicle Make   Vehicle Model

Audi                  S8Saloon

                         S7

                         Q7

                         AR1.8

Ashok Leyland   Ashok Leyland

                        Bus

                         Refrigerator

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

Aggr(IF(Rank(((Paid+OS)/Premium),19)<=20,Vehicle_Make),Vehicle_Model,Vehicle_Make)

I need to show Vehicle model also in the dimension as above example

Please anyone suggest me.

Regards

Krishna

9 Replies
ToniKautto
Employee
Employee

Do you have a sample QVW that you could attach to make it easier to work out the required expression?

krishna20
Specialist II
Specialist II
Author

Hi Toni,

Thank you for reply.

Here with i attached the sample app.

ToniKautto
Employee
Employee

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.

krishna20
Specialist II
Specialist II
Author

Hi Toni,

Sorry, I need to show two dimensions in pivot table. Among that i need to show top 20 based on parent dimension.

Please suggest me based on this requirement.

vvvvvvizard
Partner - Specialist
Partner - Specialist

Use input box

CHnage sort order

krishna20
Specialist II
Specialist II
Author

Hi ,

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.

krishna20
Specialist II
Specialist II
Author

Sorry missed to attach.Please find here.

ToniKautto
Employee
Employee

I am not sure I completely understand what 20 values you expect to find. 20 values or 20 rows?

Could you provide an excel sheet that shown the result you expect to find in chart?

krishna20
Specialist II
Specialist II
Author

Hi Tony,

Please find the attached excel. I mentioned in the excel sheet clearly . If you need any clarification  further kindly ask .