Sorting a concatenated dimension

[rdsuperlike]

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

[crystles]

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?

[rdsuperlike]

Expression Ascending

[rdsuperlike]

I got it. I needed to add =date in the expression. so that it can sort by the date.

[robert_mika]

You field become a string

Look here for some solution

learnqlickview.com/dual-function-in-qlikview/

How to use- Dual()

Feeling Qlikngry?

How To /Missing Manual(18 articles)

[MarcoWedel]

you could also create a combined field like

2015/10/21 - ABC345

to sort as text.

hope this helps

regards

Marco