Need Help with if statement and variable

[#1]

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]

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]

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;

[#4]

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

[#5 · Accepted solution]

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