topic Re: Conditional expression Query in QlikView

Conditional expression Query

300sss300 — Wed, 25 Nov 2020 16:16:04 GMT

HI,

In retail performance executive dashboard the following conditions have been used in Top Store by Sales table:

Expressions:

1. Sales (conditional) vTop=1

2. Fresh Food Sales vTop=2

3. Customer Satis vTop=3

and in icon the following values have been assigned to the variable vTop

=if(vTop<3, $(vTop)+1, $(vTop)-2)

just wanna understand and learn 2 things:

a) what is the meaning of saying if vTop<3 then vTop+1 else vTop-2 could not understand +1 and -2 if anyone please explain in detail.

b) what if we have another expression with condition vTop=4 then what will be value for variable vTop in action section.

Best Regards,

jonathandienst — Mon, 14 Jan 2019 06:51:28 GMT

The expression causes the variable to cycle 1, 2, 3, 1, 2, 3... as the action is triggered.

For 4 values
=if(vTop < 4, vTop + 1, vTop - 3)

Or use Mod:
=Mod(vTop, 4) + 1

300sss300 — Mon, 14 Jan 2019 13:59:50 GMT

Thanks!

Perfect explanation and solution.