Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
simoevry
Not applicable

Hide numbers

Hi

I want to hide numbers for example :

FROM TABLE CASES

COL1

00000000000012304 => 12304

0000000000000040012=> 40012

3 Replies
bill_markham
Not applicable

Re: Hide numbers

Looks like your COL1 field is in text format.

Try converting it to numeric format, maybe something like this :

     num(COL1)

surendraj
Not applicable

Re: Hide numbers

Try with

replace(trim(replace(COL1,'0',' ')),' ','0') as COL1

simoevry
Not applicable

Re: Hide numbers

Thanks for all