topic Re: the issue about excluded values in QlikView

the issue about excluded values

Anonymous — Tue, 28 Jul 2015 14:11:31 GMT

Hi,

I need to set the following condition:

if value 'A' in field 'B' is possible to select, then Test=1, else Test=0.

Is it possible to set such an expression in QlikView?

Thank you in advance,

Larisa

antoniotiman — Tue, 28 Jul 2015 14:17:03 GMT

In script

Load

If(B='A',1,0) as Test

Anonymous — Tue, 28 Jul 2015 14:39:58 GMT

Maybe I explained not clear enogh.

I mean if value 'A' in field 'B' is possible to select taking into account other selections at a particular moment, then Test=1, else Test=0.

I see that loading another field won't help.

johanlindell — Tue, 28 Jul 2015 14:51:02 GMT

Providing you don't have too much data you can "Concat" the field B and look for "A" in that string. You need to add a "divider" character.

Formula for Test variable:

=If (Index ('|' & Concat (DISTINCT B, '|') & '|', '|A|'), 1, 0)

antoniotiman — Tue, 28 Jul 2015 14:51:09 GMT

Maybe Expression

If(B='A',Sum({<Test={1}>} Value),Sum({<Test={0}>} Value)

Anonymous — Tue, 28 Jul 2015 15:04:51 GMT

It works. Thank you!