prefix avoid zeros in dimension

[Srinivas]

Dear all,

Before Avoid zeros in My dimension.

can you resole ASAP..

000000000000001613
000000000000001614
000000000000001615
000000000000001616
000000000000001617
000000000000001618
000000000000001619
000000000000001620
000000000000001621
000000000000001622
000000000000001623
000000000000001624
000000000000001625
000000000000001626
000000000000001627
000000000000001628
000000000000001629

Thanks

Reddy

[Srinivas]

My Dear Friend,

I tried but,It's not working can you do another solution it would be great help full....

Thanks& Advance

Munna

[Srinivas]

My Dear Friend,

I tried but,It's not working can you do another solution it would be great help full....

Thanks& Advance

Munna

[Srinivas]

Hi,

Here my fields not fixed always some time 4 digits and some times 5 digits.

[#5]

Attached with answer. Can you check it out.

Thanks

AJ

[jerem1234]

I would think one of the solutions here would work. I have attached an example of using num and num#(). If none of the solutions listed here work, I would suggest uploading your app or an example of the problem you are facing (might be more complex than we thought).

Hope this helps!

[MK_QSL]

Try

NUM(Evaluate(YourFieldName),'#0') as YourFieldName

[veidlburkhard · Accepted solution]

Hi Munna,

I loaded your data with leading zeros into QV and found this solution:

LOAD RawData,

  replace(ltrim(replace(RawData,'0',' ')),' ','0') as NumData

FROM

[http://community.qlik.com/thread/110099]

This expression in a first step replaces all zeros with spaces, then the ltrim function eleminates all leading zeros. At last zeros which have been replaced in the relevant number with spaces, too are again switched to zeros.

Hope this helps

Burkhard

[jerem1234]

Looks like I provided an example that probably exemplifies why it doesn't work

Seems like num and num# has problems when the number exceeds 14 digits. I believe some of the new solutions provided below should solve the issue.

[Srinivas]

Hi Manish,

It's working only for numeric only but not string and numeric.

like..

200N17000

200P30IF0

200P30000

000000000000001613

000000000000001614

000000000000001616

000000000000001618

000000000000001619

000000000000001621

000000000000001623

000000000000001624

000000000000001626

1681J1400N

000000000000001705

000000000000001718

1872E01000

2260V02000

Advance

Munna