I have a pivot table to show country performance over years, and I need to let the user to select the sorting order by year on demand.
I tried setting the Sorting by Sum(Sales) by that will sum up all sales from all years selected, and I cannot sort by 2012 in specific
My data in the database is stored in the format
How can I pick any year (say 2012) and sort the sales by that year?
Moreover, can I do a sorting by 2014 first then 2013?
What if I have 2 expressions (both Sales and Margin) under each year, and I want to further enhance the table to sort any of those columns?
Last but not least, I would still the option to sort by the Country name.
Thanks a million!
In fact I do not need a clean and neat, and I accept workaround. I guess some advanced formula with set analysis may help, but I do not know how that could be applied. The problem I have is that we had a old BI tool just allow us to do sorting by column on demand, and we think QV is a better tool and should be able to that as well.
Thanks for your replies!
In the below 2 video's Christof Schwarz shows some workarounds in order to get a pivot table to sort any way you want it. I think the 1st might apply more to your requirement, in that you enable the customer to sort by any column (ascending or descending) by a simple click.
He does show it in Qlik Sense - no idea if you can mimic this in QlikView