Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Employee
Employee

Re: Top 20

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

Highlighted
Specialist II
Specialist II

Re: Top 20

Hi Toni,

Thank you for reply.

Here with i attached the sample app.

Highlighted
Employee
Employee

Re: Top 20

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.

Highlighted
Specialist II
Specialist II

Re: Top 20

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.

Highlighted
Creator III
Creator III

Re: Top 20

Use input box

CHnage sort order

Highlighted
Specialist II
Specialist II

Re: Top 20

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.

Highlighted
Specialist II
Specialist II

Re: Top 20

Sorry missed to attach.Please find here.

Highlighted
Employee
Employee

Re: Top 20

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?

Highlighted
Specialist II
Specialist II

Re: Top 20

Hi Tony,

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