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.