topic Re: Add leading zeroes to a variable in QlikView

Add leading zeroes to a variable

qlikmark1990 — Mon, 18 Jun 2018 12:41:39 GMT

Currently I have this loop that has the output:

FOR vraagNummer = 1 TO 6

TRACE $(vraagNummer);

NEXT

How can I add leading zeroes to the variable to get the output :

001

002

003

004

005

006

In other topics I only read about leading leading zeros to fields instead of variables. If the loop goes further than 10 I'd like to get :

010

011 ect. untill 999

....

999

Re: Add leading zeroes to a variable

benoitgochel — Mon, 18 Jun 2018 12:53:28 GMT

Hi Mark,

Try something like this :

if(vraagNummer > 99) then

    SET output = $(vraagNummer );

    elseif (vraagNummer > 9) then

    SET output = 0$(vraagNummer );

    else

    SET output = 00$(vraagNummer );

endif;

Hope that helps.

Best regards

Re: Add leading zeroes to a variable

Anonymous — Mon, 18 Jun 2018 13:08:42 GMT

Hello,

Try this:

FOR vraagNummer = 1 TO 6

Let Number = Num($(vraagNummer), '000');

TRACE $(Number);