topic Re: Fiscal Period (5 not 005) in QlikView

Fiscal Period (5 not 005)

tmumaw — Wed, 19 Jun 2013 13:28:52 GMT

Group need alittle help. Take a look at the statement below:

LET vFisPd = if(len('$(vFisPd)' - 1) < 2, '00', '0') & '$(vFisPd)' - 1;

vFisPd is equal to 006, but my final outcome is 5 and should be 005. Any ideas?

Thanks

Wed, 19 Jun 2013 14:34:52 GMT

Hi,

try with the function Concat()

LET vFisPd = if(len('$(vFisPd)' - 1) < 2, Concat('00'& '$(vFisPd)' - 1),Concat('0'& '$(vFisPd)' - 1)

Rebeca

Anonymous — Wed, 19 Jun 2013 14:45:06 GMT

If you want the result to be fixed length (three digits), you can use formating:

num(<whatever>, '000')

Regards,

Michael