Export to Excel

[Anonymous]

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

[el_aprendiz111 · Accepted solution]

Hi,

expression

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

[Anonymous]

Thanks for the answer