topic Re: Need Help with if statement and variable in QlikView

Need Help with if statement and variable

Fri, 24 May 2013 12:11:24 GMT

Hello all together,

I need an upper barrier which depends on a counter of lines ($(i)).

i Tried to set the barrier like this:

if (($(i) = $(vNoOfRows)), set $(bisFrageZeilennr) = $(vbishöchsteZeilennr));

Unfortunately this doesn't work.

Can someone tellme where I made a mistake ?

Best regards

Purlax

alexandros17 — Fri, 24 May 2013 12:17:20 GMT

if (($(i) = $(vNoOfRows)), set bisFrageZeilennr = $(vbishöchsteZeilennr));

set assign a value (a variable in this case) to a new variable identifier that is defined without $(..)

kumarnatarajan — Fri, 24 May 2013 12:22:46 GMT

Hi,

Where you creating the this Condition.

You can't able to create variable in load.

else you are creating outer of load use below syntex.

Ex:

if $(i) = $(vNoOfRows) then

set $(bisFrageZeilennr) = $(vbishöchsteZeilennr);

ELSEIF;

Fri, 24 May 2013 12:57:48 GMT

Thanks for your replies.

Unfortunately nothing of this works.

The comma is always underlined red and Qlikview tells me .

The "set" gives me a similar answer.

: (

Here is the whole file

Fri, 24 May 2013 14:26:25 GMT

Ok,

now I combined your advices to a working line.

if $(i) = $(vNoOfRows) then

set bisFrageZeilennr = $(vbishöchsteZeilennr);

ENDIF

Thank you very much for your help !

Best regards

Purlax33