topic Re: convert weekday format in QlikView

convert weekday format

prabhas277 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

let currently we are in week number 20 the format should be "00" only. if the week number is below "10" then u should be show like 2 digits.

For example now week number is 6 but i want like "06". and i want these change in front end textbox.

Please help me

Thanks In advance..

Regards,

Prabhas

sunny_talwar — Thu, 26 May 2016 11:18:57 GMT

Try this -> Num(Week, '00')

Anonymous — Thu, 26 May 2016 11:19:11 GMT

Num(YourExpression,'00')

Kind regards.

tamilarasu — Thu, 26 May 2016 11:23:32 GMT

Another solution could be,

Right('0' & Week ,2)