keep value format constant by expression while export

[rohitk1609]

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‌

[sunny_talwar]

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

[rohitk1609]

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

[sunny_talwar]

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]

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