Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
markusvarian
New Contributor II

Export to Excel

Hi All

Please see the file attached.

Now my problem: When I export the table to Excel, the numbers aren't formatted in the same way as they are in QlikView. Why? and how can I solve this?

What I've tried so far: Formatting Numbers within the 'Chart Properties' in the Tab 'Number' works. But I want the user to be flexible to choose which format (M or K-Values) they want to see in the table.

And I don't want to create a Column with M-Values and a column with K-Values and show and hide them with conditionals. The table I have in my project will become to large.

Thanks in advance for any ideas.

Regards,

Markus

Tags (2)
1 Solution

Accepted Solutions
el_aprendiz111
Valued Contributor

Re: Export to Excel

Hi,

expression

=num#(NUM(sum(VAL_Sales_USD)/$(eFormat),eDecimal))

2 Replies
el_aprendiz111
Valued Contributor

Re: Export to Excel

Hi,

expression

=num#(NUM(sum(VAL_Sales_USD)/$(eFormat),eDecimal))

markusvarian
New Contributor II

Re: Export to Excel

Thanks for the answer