Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
jblomqvist
Valued Contributor

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

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>>>

<1

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?

2 Replies
MVP
MVP

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 the sort tab, enable both Expression and Numeric Value. PFA

MVP & Luminary
MVP & Luminary

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

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

- Marcus