Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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)
4 Replies
Tiago_Valls
Contributor II
Contributor II

Hello, 

Maybe is better you change the null for a text.

Bye

Janneke
Creator
Creator
Author

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
Author

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

We are using Qlik Sense Business.

shloime
Contributor III
Contributor III