Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am facing an issue in qliksense
I have Account ID data in GCP as
0000362722020
0000282828291
0000282728390
After loading in qlik, and adding the column to the table, the data becomes
0362722020
0282828291
0282728390
It's keeping a single Zero from the front but if I search the values from top of the column or add its filter pane then the exact data is showing there with all the zeros in the front
I tried using the Text() function in script as well but it didn't help
Does anyone has any solution for the above mentioned issue
If you know it is a 10 digit number, then I think you you can use my suggested solution.
Num([Account ID], '0000000000') as [Account ID],
Text() will usually store a text version of what's store in the source. Are you positive that the values are stored as a 13 digit value and not 10 digit?
A way/workaround to force 13 digit values when loading is to format the number using num() like this.
Load
Num([Account ID], '0000000000000') as [Account ID],
...
It's a 10 digit number only with Three Zeros in front I gave the number just for an example
Data is 0003433480
If you know it is a 10 digit number, then I think you you can use my suggested solution.
Num([Account ID], '0000000000') as [Account ID],
Thanks 👍👍
Can you help in one more issue
It's a data value for occurence
Which can be from start from 0, but end value can have any number of digits, so values can be
00,01,02,11,58,103 and etc, for single digits I need a zeros in front
Now in qlik I want the data as a number not as text() fir this column
But if I use num() it removed 0
Can you help in this too
Num(field, '00') should do what you want.
Thank you so much for your help
I appreciate it