topic Re: Sorting a concatenated dimension in QlikView

Sorting a concatenated dimension

rdsuperlike — Wed, 21 Oct 2015 20:56:40 GMT

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 — Wed, 21 Oct 2015 21:02:11 GMT

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 — Wed, 21 Oct 2015 21:43:50 GMT

Expression Ascending

rdsuperlike — Wed, 21 Oct 2015 21:48:01 GMT

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

robert_mika — Wed, 21 Oct 2015 21:49:47 GMT

You field become a string

Look here for some solution

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

Feeling Qlikngry?

MarcoWedel — Wed, 21 Oct 2015 21:57:55 GMT

you could also create a combined field like

2015/10/21 - ABC345

to sort as text.

hope this helps

regards

Marco