topic Re: keep value format constant by expression while export in Management & Governance

keep value format constant by expression while export

rohitk1609 — Fri, 16 Jun 2017 12:26:16 GMT

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‌

Re: keep value format constant by expression while export

sunny_talwar — Fri, 16 Jun 2017 12:28:03 GMT

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

Re: keep value format constant by expression while export

rohitk1609 — Fri, 16 Jun 2017 12:34:00 GMT

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

sunny_talwar — Fri, 16 Jun 2017 12:41:27 GMT

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

Re: keep value format constant by expression while export

rohitk1609 — Fri, 16 Jun 2017 12:51:42 GMT

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