remove "-" from excel exports in null cells

jdegardin · ‎2025-02-13

Hello,

I have a pivot table (Pivot Table object) in Qlik Sense. When I want to export it to Excel, I have hyphens that replace the null values. How to not have a hyphen but empty cells ?

Pivot table in Qlik Sense :

excel export with hyphens:

thanks in advance

Qlik Sense Business

morgankejerhag · ‎2025-02-13

No perfect solution as far as I know. Most often the problem is that there is no data for the combination of dimensions. So to get values there you must fill the data. Let's say I have a pivot with Country and YearMonth (from the same table in the data model). I can then make sure I have all combinations in my data and then it will work to expert (becomes 0s instead of dashes). But this will be difficult if there are lot of possible combinations etc.

FillOut:

Load distinct

Country

resident Data;

left join

Load

YearMonth

resident Data;

Concatenate (Data) Load * resident FillOut;

drop table FillOut;

General Question