Skip to main content
Announcements
MAINTENANCE ALERT: Search experience upgrade - Feb 6: 4 - 8:30AM CET. Downtime expected. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sunny_ryuke
Partner - Contributor II
Partner - Contributor II

Qlik auto suppressing Zeros from front of values

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

Labels (1)
2 Solutions

Accepted Solutions
Vegar
MVP
MVP

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],

View solution in original post

Vegar
MVP
MVP

Num(field, '00') should do what you want.

View solution in original post

7 Replies
Vegar
MVP
MVP

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],

...

sunny_ryuke
Partner - Contributor II
Partner - Contributor II
Author

It's a 10 digit number only with Three Zeros in front I gave the number just for an example

 

Data is 0003433480

Vegar
MVP
MVP

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],

sunny_ryuke
Partner - Contributor II
Partner - Contributor II
Author

Thanks 👍👍

sunny_ryuke
Partner - Contributor II
Partner - Contributor II
Author

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

 

Vegar
MVP
MVP

Num(field, '00') should do what you want.

sunny_ryuke
Partner - Contributor II
Partner - Contributor II
Author

Thank you so much for your help 

I appreciate it