topic Re: added text in load in QlikView

added text in load

patrou38 — Fri, 24 Mar 2017 15:20:42 GMT

Hello,

In the load function, I would like to test if my WEEK is with 2 digits and if not I would like to add a Zero before.

The below expression doesn't work 🙂

someone could help me ?

LOAD
Year&
if(len([Week]>1),[Week],'0'&[Week]) as ID_Temps,
...
FROM ...

Thank you in advance,

Patrick

vishsaggi — Fri, 24 Mar 2017 15:25:29 GMT

Try this?

IF(Len(Week) < 2, 0&Week, Week)

if(len([Week]) >1, [Week], 0&[Week]) as ID_Temps,

krishnacbe — Fri, 24 Mar 2017 15:26:21 GMT

Try below expression

if(Len(Week)=1, 0 & [Week], [Week]) as ID_Temps

m_woolf — Fri, 24 Mar 2017 15:26:34 GMT

What results are you getting with that expression?

Maybe:

if(len([Week]>1),text([Week]),text('0'&[Week])) as ID_Temps,

patrou38 — Fri, 24 Mar 2017 15:33:44 GMT

It works, thank you 🙂

patrou38 — Fri, 24 Mar 2017 15:47:58 GMT

This expression works also (and it's more simple from my point of view 😉

thank you for all

patrou38 — Fri, 24 Mar 2017 15:49:28 GMT

the result is that a Zero was added before my number with 1 digit . I have 01 instead 1 and for the number like 10, 11, 12 they stay as they are 😉