topic Re: expression as string in if clause in QlikView

expression as string in if clause

Sergio3 — Tue, 11 Jun 2019 09:32:00 GMT

Hi, mates.

Help me.

How to put expression as string in if clause?

For example:

IF(vTEST=0, SUM(x),0)

Expression in chart:

SUM(Y)+$(vTEST)

vTEST need to be like 'SUM(x)', like SET in script.

Thanks!

gf — Tue, 11 Jun 2019 11:30:15 GMT

Hello Sergio,

I would use two variables.

vTest and vTest2.

vTest is your number and in vTest2 you check vTest with =IF(vTest=0,Sum(x),0)

Then you can calculate with vTest2 like =Sum(y)+$(vTest2)

Regards,

gf — Tue, 11 Jun 2019 11:33:43 GMT

Have a look at this simple program for better understanding.

Sergio3 — Tue, 11 Jun 2019 12:44:10 GMT

Thank u sir!