Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

rohitk1609
Valued Contributor II

keep value format constant by expression while export

Hi All,

I have a table which is giving values in format i.e 12345678.10 so I have added NUM function to change its format to Num('12345678.10',##,###.##0) and now it is displaying as 12345,678,10 but when I export it , it again comes as it was 12345678.10.


If I change this expression format by configuration=> Number=>1,000.12 , it works fine even with export, but I don't want to use it  because I don't want client drag this expression to new chart and change format every time. I want to do it on expression level.


Same I want to make my another expression format to XX.YY% on expression level its must work on export file to excel too.


Thanks in advance! stalwar1

Tags (1)
4 Replies

Re: keep value format constant by expression while export

Don't think you can do what you want with Num() function. The other alternative would be to use Macro...

rohitk1609
Valued Contributor II

Re: keep value format constant by expression while export

Can you please help me to write macro in Qlik sense. I have no experience in writing macro.

Re: keep value format constant by expression while export

Unfortunately, I have never written a Macro for Qlik Sense either... May be someone else might be able to offer you some help here.

All the best,

Sunny

rohitk1609
Valued Contributor II

Re: keep value format constant by expression while export

Any other option which makes value comes with mentioned format in expression ?