Qlik Community

Qlik Sense Ideas

Ideas for Qlik Sense products.

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


Natural management of completly null field in set analysis


This idea makes reference to this issue


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




Buuuuuuuuuuuuuuuuuuut let's have this table without the last row

not a big deal, you may think...




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,


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

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