topic Re: 'Sort' tub in Chart properties in QlikView

'Sort' tub in Chart properties

Anonymous — Tue, 26 Apr 2016 12:31:53 GMT

Hi,

I need to set an expression in Chart properties on 'Sort' tub.

I would like to set a specific order of values for a dimension like =ValueList('ValueX','ValueA','ValueU')

But the function ValueList doesn't have any affect on the Chart.

Could you please give advice?

Thank you in advance,

Larisa

MK_QSL — Tue, 26 Apr 2016 12:34:41 GMT

Try below

Only({1}Pick(Match(YourDimension,'ValueX','ValueA','ValueU'),1,2,3))

sunny_talwar — Tue, 26 Apr 2016 12:39:01 GMT

Manish do we need Pick here? Match itself won't be enough?

Tue, 26 Apr 2016 12:50:29 GMT

Hi Larisa, I try and also I can't.

You should try to add an id_number for each value in the script, doing this:

value , id_number

'x' , 1

'a' , 2

'u' , 3

and then in the tab 'Order' order by expresion and put this: =id_number (ascending or descending like you prefer)

I hope that it help you!

Agustín