Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
PFA.
Can you please suggest how to sort this app in descending order as per monthyear .
Mean first start from most recent month year to least recent month year column.
Thanks
The whole app needs to be sorted or specific chart? I have not opened it yet, but just wondering
Hi Deepak,
I think this is Not possible.
A pivot table is always sorted first after the first dimension, then the second dimension, etc. This is necessary since the rows are grouped first after the first dimension, then the second dimension, etc. If you want to sort after an expression, you should use a straight table instead.
Have look on this, it might be helpful for you-
https://community.qlikview.com/docs/DOC-7220
Thanks,
Neha