Qlik Community

Qlik Sense Ideas

Ideas for Qlik Sense products.

Natural management of completly null field in set analysis

Partner
Partner

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
Tags (2)
2 Comments
Community Manager
Community Manager
 
Employee
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