topic Max 10 or Min 10 Value in PivotTable. in QlikView

Max 10 or Min 10 Value in PivotTable.

sona_sa — Thu, 16 Feb 2012 10:11:15 GMT

Hi,

Do we have maximum no. of sale in pivot table. We can do it in all chart including straight table also, but in pivot table there is no option.

Regards,

A Kumar

Anonymous — Thu, 16 Feb 2012 11:21:42 GMT

Hi,

Try this in Exp

=Sum({<Region={"=Rank(Sum(Sales))<6"}>} Sales)

Regards,

Snehal

sona_sa — Thu, 16 Feb 2012 11:26:12 GMT

Hi Snehal,

Thanks for replpy, But can you check it for multiple dimesion.

Regards,

A Kumar

jagan — Thu, 16 Feb 2012 11:28:09 GMT

Hi,

Try using Total in the Rank()

=Sum({<Region={"=Rank(TOTAL Sum(Sales))<6"}>} Sales)

Regards,

Jagan.