Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
expression
=num#(NUM(sum(VAL_Sales_USD)/$(eFormat),eDecimal))
Thanks for the answer