Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Natural management of completly null field in set analysis

simonaubert
Partner - Specialist II
Partner - Specialist II

Natural management of completly null field in set analysis

Hello,

This idea makes reference to this issue
https://community.qlik.com/t5/Qlik-Sense-App-Development/NULL-FIELD-PROBLEM-IN-SET-ANALYSIS/td-p/138...

 

So, let's say you have this table

 

and you must sum the measure when the field Dimension_2 is not null. You will write :
Sum({$<Dimension_2= {"*"}>} Measure}

And it works fine

image.png

 

 

Buuuuuuuuuuuuuuuuuuut let's have this table without the last row

not a big deal, you may think...

 

image.png

 

Surprise !!
The set analysis {$<Dimension_2= {"*"}>} is not even taken into account !

Frankly, and given the fact that this behaviour is not documented , I would consider that a bug and a big one.

Please, Qlik, can you have this working as expected?

Best regards,

Simon

Bi Consultant (Dataviz & Dataprep) @ Business & Decision
1 Comment
John_Teichman
Former Employee
Former Employee

I am closing this item. There is often a difference between working as designed and working as expected. I recommend opening this as a bug with Qlik Product Support (https://support.qlik.com/).

Status changed to: Closed - Declined