Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist II
Specialist II

How I can remove leading zeroes

Hello, colleagues.I have a small problem, which I can't resolve elegant.

I want to remove leading zeroes from my Data.

I tried to do some text / num converting, but it didn't help me.

See attached file

31 Replies
Highlighted
Partner
Partner

'0000010 * 1'  = 10

Highlighted
Contributor
Contributor

In my case I had both numeric and alphanumeric values in the same field.

Below worked for me..

if(Isnum(num(Num#(PROFIT_CTR))),text(num(Num#(PROFIT_CTR))),PROFIT_CTR)

 

Swapnil