Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

rdsuperlike
New Contributor III

Sorting a concatenated dimension

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

5 Replies
crystles
Contributor III

Re: Sorting a concatenated dimension

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
New Contributor III

Re: Sorting a concatenated dimension

Expression Ascending

rdsuperlike
New Contributor III

Re: Sorting a concatenated dimension

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

Re: Sorting a concatenated dimension

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)

Re: Sorting a concatenated dimension

you could also create a combined field like

2015/10/21 - ABC345


to sort as text.


hope this helps


regards


Marco

Community Browser