Discussion Board for collaboration on QlikView Layout & Visualizations.
I want to sort a concatenated dimension in a line chart.
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.
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?
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
How to use- Dual()
How To /Missing Manual(18 articles)
you could also create a combined field like
2015/10/21 - ABC345
to sort as text.
hope this helps