topic Re: Top 20 in QlikView

Top 20

krishna20 — Sun, 17 May 2015 06:45:55 GMT

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

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

Re: Top 20

ToniKautto — Sun, 17 May 2015 06:51:01 GMT

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

Re: Top 20

krishna20 — Sun, 17 May 2015 07:21:48 GMT

Hi Toni,

Thank you for reply.

Here with i attached the sample app.

Re: Top 20

ToniKautto — Sun, 17 May 2015 08:06:27 GMT

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.

Re: Top 20

krishna20 — Sun, 17 May 2015 08:19:02 GMT

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.

Re: Top 20

vvvvvvizard — Sun, 17 May 2015 08:41:45 GMT

Use input box

CHnage sort order

Re: Top 20

krishna20 — Sun, 17 May 2015 09:03:50 GMT

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.

Re: Top 20

krishna20 — Sun, 17 May 2015 09:05:31 GMT

Sorry missed to attach.Please find here.

Re: Top 20

ToniKautto — Sun, 17 May 2015 09:16:51 GMT

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?

Re: Top 20

krishna20 — Sun, 17 May 2015 09:50:46 GMT

Hi Tony,

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