topic Based on Condition the EditScript should be Reload in QlikView

Based on Condition the EditScript should be Reload

jagannalla — Wed, 25 May 2011 05:48:39 GMT

Hi,

- I want to keep a conditon in reload editscript. In the below following format.

if(vGlobalId=0)

{

I want to reload few tables here i.e table1,table2,table3...etc

}

else

{

I want to reload few tables here i.e table4,table5,table6...etc

}

Is it possible to do this? if possible how can i do this can anybody help me.

Also i need answer whether it possible or not.

Anonymous — Wed, 25 May 2011 06:16:44 GMT

Sure you can do if/else/then statements in the script. A good source is the F1 help. Here's an example on the syntax:

if x>0 then

load * from pos.csv;

elseif x<0 then

load * from neg.csv;

else

load * from zero.txt;

end if

(do note though that if you want to load a certain table regardless of the variable value, you'll want to place it outside the condition)

jagannalla — Wed, 25 May 2011 06:51:14 GMT

Thanks a lot jsn it's working fine...