Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Another easy question: I have a file with numbers in the format "01" but when uploaded to Qlikview it changes this to "1". How do I make it retain the "01" format?
in load use
text(yourfield)
Update sorry i misplace the Text function now you can check
Write like
Load
Num(YourField,'000') as Yourfield1 //if you want to make it 001
Num(YourField,'00') as Yourfield2 //if you want to make it 01
From Location;
OR
Load
Text(YourField) as Yourfield1
From Location;
Hi John,
I'd recommend using Text() and Dual() function. This way you can keep the text formatting and also perform aggregation as a number field.
See the attached example.
I hope this helps!
Cheers,
DV
www.QlikShare.com
Use below in script...
Num(YourFieldName,'00') as YourFieldName;
Hi,
Please read attached documentation. It explains why and how to avoid this issue
Thanks Joseph. Good to get insight from QlikTech.
Cheers,
DV