topic Re: Sort a chart Dimension by two specific values first and then take the rest as it is from the Dimension field? [Example provided] in QlikView

Sort a chart Dimension by two specific values first and then take the rest as it is from the Dimension field? [Example provided]

jblomqvist — Fri, 04 Sep 2015 10:06:28 GMT

Hi all,

I have a Bar chart with following Dimension values in the Useful Life dimension field.

In there I would like to sort by values:

<<<Blank>>>

and then the rest of the values from the dimension field.

I would like to ensure the first bar is <<<Blank>>> followed by <1, and then the rest of the order is by values in the Useful Life field. The rest of the values are numberic so it could be 5, 7, 12. 13, 21 etc.

How can I do this?

I tried using the Match fun like Match(Useful Life, '<<<Blank>>>, '<1', Useful Life) but it did not work.

Any suggestions?

Re: Sort a chart Dimension by two specific values first and then take the rest as it is from the Dimension field? [Example provided]

tresB — Fri, 04 Sep 2015 10:24:03 GMT

In the sort tab, enable both Expression and Numeric Value. PFA

Re: Sort a chart Dimension by two specific values first and then take the rest as it is from the Dimension field? [Example provided]

marcus_sommer — Fri, 04 Sep 2015 10:24:58 GMT

Maybe in this way: if([Useful Life] = '<<<Blank>>>', -1, [Useful Life])

- Marcus