Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to sort a concatenated dimension in a line chart.
eg:
i have date and Id column which i have concatenated in the script as date-ID
10/21/2015 - ABC345
10/22/2015 - RTU123
10/23/2015 - THYUNV
and so on.
When i display a line chart on x axis i have this date-ID column and some qty on y axis.
I want the dates to be sorted from lowest to highest date-ID based on date values. How do I sort it?
Any help is appreciated.
Thanks
You should be able to Sort it just like any other field.
In your Properties under Sort tab, which option(s) do you have selected?
Expression Ascending
I got it. I needed to add =date in the expression. so that it can sort by the date.
You field become a string
Look here for some solution
learnqlickview.com/dual-function-in-qlikview/
Feeling Qlikngry?
you could also create a combined field like
2015/10/21 - ABC345
to sort as text.
hope this helps
regards
Marco