This content has been marked as final. Show 6 replies
I'm a newbie to Qlik Sense Desktop.
I have an app and a KPI that sum sales (measure) of all the departments (dimension).
There are certain departments that ar null but have sales. I would like not to sum those sales.
Here's the table:
My KPI object shows 50. How can I not consider the null department, and show 40?
Thanks to everyone.