topic When condition in script for set variable in QlikView

When condition in script for set variable

richters — Thu, 28 Feb 2013 08:36:28 GMT

Hi all,

I just want to set my variable when a condition is true so I tried:

when $(aktuellerMulti)>=$(j) set rundungs = $(rundungs)#$(rundung);

Anyone knows why this doesnt work and has got a solution?

Thanks in advance !

Gysbert_Wassenaar — Thu, 28 Feb 2013 08:51:28 GMT

Generally it's done with an if then else statement:

if $(aktuellerMulti)>=$(j) then

set rundungs = $(rundungs)#$(rundung);

end if

If that doesn't work you'll have to explain what you're trying to do and how, i.e post the script or better, post the document your working on.

richters — Thu, 28 Feb 2013 11:48:40 GMT

Works great, but why the hell is there the when-condition available? I really dont get it.

swuehl — Thu, 28 Feb 2013 11:55:34 GMT

This works for me:

Let a = 1;

When a=1 Set B = 2;

So maybe just try:

when aktuellerMulti >= j set rundungs = $(rundungs)#$(rundung);