Setting up variable value in script

Anonymous — Mon, 21 Jan 2013 19:39:30 GMT

Hi,

I am trying to setup variable value as 01 instead of 1.

I can do that using below

let

vday='01';

But I want to loop above variable into For loop and when I add "1" to vday I get "2" but I am looking for "02" value.

Reson for doing this is I want to form a string so that I can read data from partition created in format ABC_2012_09_01,ABC_2012_09_02 etc

How to achieve this any idea?

Sample code

let

vPart='TRAN_PART_2012_12_';

let vday='01';

set vzero=0;

For i=1 to 31

set vMainPartition=$(vPart)$(vday);

Thanks

Re: Setting up variable value in script

Mon, 21 Jan 2013 20:05:28 GMT

You should use the Num() function to format a number in the way you want: Num(vday, '00') will use always two digits to show the vday value.

topic Setting up variable value in script in QlikView

Setting up variable value in script

Re: Setting up variable value in script