topic Re: Exporting Raw Data to Excel disregarding the formatting in App Development

Exporting Raw Data to Excel disregarding the formatting

michisull — Thu, 07 Jul 2022 14:31:30 GMT

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!

Re: Exporting Raw Data to Excel disregarding the formatting

Ray_Strother — Thu, 07 Jul 2022 15:17:04 GMT

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/1912618#:~:text=Unfortunately%2C%20Qlik%20Sense%20does%20not,but%20only%20on%20regular%20tables.

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...

Re: Exporting Raw Data to Excel disregarding the formatting

marcus_sommer — Fri, 08 Jul 2022 09:34:53 GMT

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

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

- Marcus