Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

prashantsanchet
Contributor

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
Valued Contributor

Re: Qliksense Pivot table sorting value based on measure

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

Cheers

Luis

luismadriz
Valued Contributor

Re: Qliksense Pivot table sorting value based on measure

Like this?

Capture.PNG

luismadriz
Valued Contributor

Re: Qliksense Pivot table sorting value based on measure

Hi Prashant,

Please let me know if you still have this question.

Cheers,

Luis

Community Browser