Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
prashantsanchet
Creator
Creator

Qliksense Pivot table sorting value based on measure

How we can sort a pivot table based on measure value.

i have requirement where i need to sort a table based on descending order of measure based on value in di,mension.

for ex : I have DIm1 , Dim2 as Row, Dim 3 as Column and sum(exprn) as measure

now i need to sort the pivot table based  on 2 condition

1 )  Dim 3 having one value for ex A

2) Entire table need to be sorted based on Descending value of Measure (sum(exprn)) for "Dim 3 value A"

3 Replies
luismadriz
Specialist
Specialist

Hi, can you please share some data? or a qvf, or screenshots?

Cheers

Luis

luismadriz
Specialist
Specialist

Like this?

Capture.PNG

luismadriz
Specialist
Specialist

Hi Prashant,

Please let me know if you still have this question.

Cheers,

Luis