Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Re: Sort in Pivot table

I did the same as Pankaj suggested but no success.


Thanks

Highlighted
Creator III
Creator III

Re: Sort in Pivot table

Can you please share a sample app?

Highlighted
Specialist
Specialist

Re: Sort in Pivot table

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