topic Logical help in QlikView

Logical help

Anonymous — Thu, 13 Apr 2017 10:57:57 GMT

Hi all,

I have field named "CSS_CurrentCEScoreR" which has range of number till 1000.I want to derive a new column from by arranging a range like 0-20,20-40 and so on from this field. I am using the Class function for this but still no data is populating. Can anyone help?

Regards

Adarsh

Re: Logical help

Anil_Babu_Samineni — Thu, 13 Apr 2017 11:02:37 GMT

May be do this

Class(CSS_CurrentCEScoreR,20) as CSS_CurrentCEScoreR1

Re: Logical help

Anil_Babu_Samineni — Thu, 13 Apr 2017 11:13:39 GMT

FYI, I used this

LOAD replace(class(RowNo(),20),'<= x <','-') as ID1 AutoGenerate 998;

Output:

Re: Logical help

Peter_Cammaert — Thu, 13 Apr 2017 12:12:29 GMT

In a User Interface expression, or in the Load script? You're not posting this in the Scripting forum, so I'm assuming you want to do this on-the-fly?

Can you post an small example document that shows this behavior?