topic Re: How to Show Top 10 Values in Pivot Table in QlikView

How to Show Top 10 Values in Pivot Table

SatyaPaleti — Thu, 06 Aug 2015 14:59:08 GMT

Hi Friends,

Attached is the data I have.

Description, Item & Inventory are the Dimensions

Cost,Current Cost,Qty & Current Qty are the fields I have to use in Expressions.

I want to show top Ten Values(Cost,Current Cost,Qty & Current Qty) in Pivot Table by Description,Item

How Can Resolve this issue?? Can any one help me in this

Thank You, Satya Paleti

Re: How to Show Top 10 Values in Pivot Table

Chanty4u — Thu, 06 Aug 2015 15:01:42 GMT

Use that fields as dimensions,

and use dimension limit value as 10 as largest or smallest watever u want.

Hope this helps you

thank you

Suresh chanty

Re: How to Show Top 10 Values in Pivot Table

SatyaPaleti — Thu, 06 Aug 2015 15:05:05 GMT

In Pivot table there will be no option 'Dimension Limits' Suresh Thank you, Satya

Re: How to Show Top 10 Values in Pivot Table

Gysbert_Wassenaar — Thu, 06 Aug 2015 15:15:02 GMT

See attached example.

If you want the items that are in the top 10 cost or in the top 10 current cost or ... etc then use expressions like sum({<Item={"=rank(sum(Cost))<11 or rank(sum([Current Cost]))<11 or rank(sum(Qty))<11 or rank(sum([Current Qty]))<11"}>}Cost)

Re: How to Show Top 10 Values in Pivot Table

SatyaPaleti — Thu, 06 Aug 2015 15:45:36 GMT

Hi,

@gwassenaar‌

Thank you for Advice. I want to show total also but I unable to get that and we have to include Inventory also in the dimension

This report should have expand and collapse by Inventory.

Thank you,

Satya

Re: How to Show Top 10 Values in Pivot Table

pratap6699 — Thu, 06 Aug 2015 20:01:22 GMT

if(aggr(rank(sum(cost) and sum(quantity) and sum(currentcost)>10,item,inventary)))