Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Janneke
Creator
Creator

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

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.

Labels (4)
3 Replies
Tiago_Valls
Contributor II
Contributor II

Hello, 

Maybe is better you change the null for a text.

Bye

Janneke
Creator
Creator

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

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

We are using Qlik Sense Business.