Qlik Community

Qlik Sense App Development

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

farisahamad
Contributor

How to retain money format while exporting data to excel?

Hi All,

I have a chart with Sales amount in y axis. But the format of the amount i have defined using num() there.

I need to get the same format in the excel sheet when it is exported.

Any help on this would be appreciated.

Thanks in advance

1 Solution

Accepted Solutions
farisahamad
Contributor

Re: How to retain money format while exporting data to excel?

The solution is to use Money() instead of num()

2 Replies
okolyug16
Contributor II

Re: How to retain money format while exporting data to excel?

If the number format is defined on the properties panel, it should carry over when exported to excel.

Number Format.PNG

farisahamad
Contributor

Re: How to retain money format while exporting data to excel?

The solution is to use Money() instead of num()