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

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

Janneke — Sat, 16 Nov 2024 19:17:07 GMT

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.

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

Tiago_Valls — Fri, 17 Jan 2020 13:45:06 GMT

Hello,

Maybe is better you change the null for a text.

Bye

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

Janneke — Fri, 17 Jan 2020 13:47:38 GMT

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.

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

Janneke — Mon, 20 Jan 2020 11:25:48 GMT

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

We are using Qlik Sense Business.

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

shloime — Mon, 04 Oct 2021 15:32:48 GMT

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/