Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm new in the community and also a new Qlikview user.
I have already looked at several posts here in the community but I couldn't find out exactly what I was looking for.
I have created this pivot table:
it has 6 dimensions, but I am going to show only 3: Country, Year and Week n° (which is a calculated dimension =week(Document_Date))
I have only 1 expression, represented by the count - distinct of the document of each country.
I have added the automatic subtotal as shown, and now I need to sort the Country by the column Total.
The week N° is also sorted by Value number.
I think I have to use "sort by expression" in the sort table, but I did so many tries with no result.
Can someone please help me?
Thank you so much.
Davide
Have you tried sorting by y value on the sort tab?
Hi Sunny, thanks for your replay!
Actually yes, but it didn't work, and on the other hand I lost the sort by value applied to the Week N dimensions.
Thanks a lot anyway.
Regards.
Davide