Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Don't think you can do what you want with Num() function. The other alternative would be to use Macro...
Can you please help me to write macro in Qlik sense. I have no experience in writing macro.
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
Any other option which makes value comes with mentioned format in expression ?