topic Re: how to classify values into dynamic groups in QlikView

how to classify values into dynamic groups

Mon, 07 Jul 2014 07:49:52 GMT

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!

MK_QSL — Mon, 07 Jul 2014 08:09:24 GMT

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

Mon, 07 Jul 2014 08:13:57 GMT

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!