Qlik Community

Qlik Sense Ideas

Ideas for Qlik Sense products.

Announcements
NOTICE: Qlik will introduce an updated Ideas program in March 2020.
In preparation, this Qlik Sense Ideas board will close February 21. Existing ideas will be moved to the new board.
Stay tuned for more information about the new Ideas program in the coming weeks!

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
1 Comment
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