topic Re: Sorting via formula problem in QlikView

Sorting via formula problem

Anonymous — Mon, 18 Feb 2013 13:28:51 GMT

dear all

I try and try to get it work, but unfortunatly I have little success.

I have a date and a number as a joined dimension. I want the dimension to be sorted like this:

12.07.2012_3

12.07.2012_1

12.07.2012_2

13.07.2012_3

13.07.2012_1

13.07.2012_2

Im using a formula to sort the date (the result of it you can see above(Figure)) :

if(Schicht = 3, CalDate&1,if(Schicht = 1,CalDate&2,if(Schicht = 2,CalDate&3)))

Any ideas ??

vivientexier — Mon, 18 Feb 2013 14:07:13 GMT

It would be easier to create in the script another column to sort your dimension.

SunilChauhan — Mon, 18 Feb 2013 14:11:09 GMT

in charts properties-> sort

check on expression and enter

if(Schicht = 3, CalDate&1,if(Schicht = 1,CalDate&2,if(Schicht = 2,CalDate&3)))

and select ascending or descending there.

Hope this helps

Anonymous — Mon, 18 Feb 2013 14:23:54 GMT

I don't understand you:

- Well the formula is entered already, but shows me not what I want. See orig post

Anonymous — Mon, 18 Feb 2013 14:25:01 GMT

That would be a possibility, but I'm curious if QlikView is that flexible that I can solve it also in a formula...

Anonymous — Mon, 18 Feb 2013 14:30:46 GMT

I ve tried also this , but without success :

CalDate& if(Schicht = 3, 1,if(Schicht = 1, 2,if(Schicht = 2, 3)))

Anonymous — Mon, 18 Feb 2013 14:36:11 GMT

Found the solution:

if(Schicht = 3, Num(CalDate)&1,if(Schicht = 1,Num(CalDate)&2,if(Schicht = 2,Num(CalDate)&3)))

thx all