Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld May 10-12, Online and Free! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ziabobaz
Creator III
Creator III

TOTAL in Set Analysis does not work when Hide Null Values is ticked in Dimension (Table chart)

hi

I have:

ziabobaz_0-1595431327456.png

where Result Name is calculated Dimension with unticked 'Include null values'

ziabobaz_2-1595431432115.png

 

and Ad Cost is:

ziabobaz_1-1595431361133.png

I want this: 

ziabobaz_3-1595431509206.png

 

But the result in Ad Cost is zero since I unticked null values in Result Name and it seems that TOTAL does not take into account those nulls.

 

Is there way I can do both 'no null values' with 'total' in Table?

FYI - that's what happens when I tick back Hide null values. Ad cost is correct, BUT there are null values in Result Name which I don't want to see:

ziabobaz_0-1595432614056.png

 

 

Thank you

 

Labels (1)
0 Replies