KPI selective sum

[luca_bellotti]

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.

[luca_bellotti]

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

[agigliotti · Accepted solution]

better if you replace null with string (ex. "n/a") in the script and use the expression as below :

Sum({$<[Department]-={"n/a"}>}Sales)

[#4]

Try this

Sum({$<[Department]-={"null"}>}Sales)

[luca_bellotti]

Thank you Andrea, that's excatly what I was looking for.

[Anonymous]

sum({<Department={'*'}>}Sales) , this will only take non null values of department

[Anonymous]

sum({<Department={'*'}>}Sales) , this will only take non null values of department