Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
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:
Department | Shop | Month | Sales |
---|---|---|---|
A | a1 | jan | 10 |
B | a2 | jan | 10 |
B | a3 | jan | 10 |
null | b1 | jan | 10 |
A | a5 | jan | 10 |
My KPI object shows 50. How can I not consider the null department, and show 40?
Thanks to everyone.
better if you replace null with string (ex. "n/a") in the script and use the expression as below :
Sum({$<[Department]-={"n/a"}>}Sales)
I've found a solution to my problem:
Sum({$<[Department]={"A"}>}Sales)+Sum({$<[Department]={"B"}>}Sales)
If somebody has a better solution feel free to share.
Thank you again.
Luca
better if you replace null with string (ex. "n/a") in the script and use the expression as below :
Sum({$<[Department]-={"n/a"}>}Sales)
Try this
Sum({$<[Department]-={"null"}>}Sales)
Thank you Andrea, that's excatly what I was looking for.
sum({<Department={'*'}>}Sales) , this will only take non null values of department
sum({<Department={'*'}>}Sales) , this will only take non null values of department