Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a pivot table with 4 dimensions and 1 expression.
D1,D2,D3,D4
The D4 dimension is a date field, which i want to sort in descending order.
Now in a single D1, D4 are not in the desired order.
Is there any way to sort it base on D4 only so that within other D1, i get all the D4 in the desired order.
I cannot change the order of the dimensions also.
Thanking in advance...
You need to post some data to get a good answer.
However, a common case is that the "date" is not interpreted as a date (meaning that it gets a numeric value also), but is instead just a string, sorted alphabetically.
See more on
http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/19/why-don-t-my-dates-work
HIC
How is D4 formatted?