Downloaded table to excel skips rows with null-value in dimension

[Janneke]

Hi all,

I have created a table with multiple dimensions and some measures. Some of the dimensions are allowed to contain null-values. When I download the table to excel, all rows with null-values in one of the dimensions are not exported.

How can we export those rows as well? Without those rows the measures don't add up to the amount in the dashboard, which means the export is not usable.

Thanks for your help.

Janneke.

[Tiago_Valls]

Hello, 

Maybe is better you change the null for a text.

Bye

[Janneke]

Hi Tiago,

This is a workaround I already tried. However, it would be better if Qlik exported all data, instead of skipping rows. Now I have to be careful for every dimension that may contain null values. Having the cell empty is information for us as well (at least in this particular case).

Janneke.

[Janneke]

Does anyone have an idea, perhaps about a general setting that we can change?

We are using Qlik Sense Business.

[shloime]

This can be done using the logiexport extension:

https://logiexport.logsys.co.il/articles/how-to-easily-control-the-values-formatting/

https://logiexport.logsys.co.il/documentation/