Exporting Raw Data to Excel disregarding the formatting

[michisull]

Hi everyone,

I want to display my sales data 1561000000 € as 1.561 bn€ in a pivot table but I want the raw number to be exported to excel. Dividing the sales by 1000000000 in the set expression num(Sum(Sales)/1000000000,'#.000 bn€', '.',',') leads to the right format, unfortunately it is no longer possible to export the the raw number.

Any suggestions how to display this type (1.561 bn€) of format and to export the raw sales amount to excel without dividing it?

Many thanks!

[Ray_Strother]

Hello ,

Perhaps you can hide the column with the raw data and format another cell . The following community post may help.

https://community.qlik.com/t5/App-Development/How-To-Hide-Column-in-Qlik-Sense-Straight-Table/td-p/1....

Unfortunately, Qlik Sense does not have the "hide column" functionality. However, there are some extensions that allow you to hide columns, but only on regular tables.

For example, VizLib has one:

https://community.vizlib.com/support/solutions/articles/35000107234-vizlib-table-properties-data-and...

[marcus_sommer]

You could try to use a dual() for it like:

dual(num(Sum(Sales)/1000000000,'#.000 bn€', '.',','), Sum(Sales))

- Marcus