Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

how to classify values into dynamic groups

I need to classify values of a field into four classes.

Depending on the values in a second field, the threshold for the classes are different.

For example.

if field2=A

0-10: Null

11-20: Low

21-40: Mid

41+: High

if field2=B

0-7: Null

8-17: Low

18-43: Mid

44+: High

etc.

in field2 I have at least 10 different values

How can I sort this out, without creating a (roughly) forty-times-nested if statement?

thanks!

2 Replies
MK_QSL
Not applicable

Re: how to classify values into dynamic groups

Crete an Inline table with Field, Value and Flag and generate in the script itself

Not applicable

Re: how to classify values into dynamic groups

thank you for your inpute. to understand better, would you create something like

LOAD * INLINE {

Value,FieldB,Class

0, A, Null

1, A, Null

2, A, Null

[..]

11, A, Low

12, A, Low

[..]

21, A, Mid

etcetc. ?

It requires so many lines.

This was the only solution I was able to think to (besides the nested if statements) but it is not so easy to be maintained!