Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
narender123
Specialist
Specialist

Sort in Pivot table

Hi Team,

I have a pivot table with 2 columns and 2 expression.

Like:

Col1    Col2     exp1    exp2

I want the exp2 in descending order.

When the pivot table not expended then the exp2 shows the amount in descending order. But when i expend the Pivot table then amount not show in descending order.


Untitled.png

I set the expression in sort but didnt get the result as i want.

Please let me know how to show the amount in descending order when pivot table is fully expended.



Thanks,


Narender

12 Replies
narender123
Specialist
Specialist
Author

I did the same as Pankaj suggested but no success.


Thanks

balar025
Creator III
Creator III

Can you please share a sample app?

anantmaxx
Specialist
Specialist

Hi Narender,

How are you??

when no cloumns are expanded chart dimnesionality is 1 and when you expand second dimensionality

increases and from 1 it become 2.

in your sort tab where you are writing  expresion sum({<Flag={8}>} TAX_AMOUNT )

write  if( dimensionality()=2, Rank(sum({<Flag={8}>} TAX_AMOUNT ) )  and check expression check box

and keep selecting drop down  as descending for both of your expression .

It may work.

Thanks

Anant Dubey

9718365394