Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to find out the biggest changers over the last two months.I need these to be sorted with the highest change and its name being displayed first using Pivot Tables.
I have created a pivot table and also added two columns with one being Difference in amounts and other being percent change. I am unable to sort these based on the highest percent change.
Please find the attached screenshot of two columns that have been calculated based on amounts. I want the result to have the highest change as first column
I am using QLIKSENSE and not Qlikview. Kindly paste the code here as I have problem opening .qvf files.
Thanks,
Mithun
Try sorting the dimension by expression as shown in the image below;
Hi,
This is not solving the issue.Both those fields are calculated fields and does not display automatically in the 'Sorting column' as you showed above.
Thanks
HI, I'm assuming the there's a dimension used on the pivot table, sorting the dimension by the measure's expression should change the sort order.
Hope this helps clarify?