set analysis fro not null values

[arusanah]

I'm writing  set analysis for total charges where charge id is not null.

Sum({<[Charge ID]-={"' '"}, REVENUE_DATE={"<= $([REPORT DATE]) "}>} TOTAL_CHARGE_AMT)

but it doesn't seems to work . it gives me same result as sum(TOTAL_CHARGE_AMT). which is not right .

Any help is highly appreciated.

[sunny_talwar]

How about this

Sum({<[Charge ID] ={"*"}, REVENUE_DATE={"<=$(=[REPORT DATE])"}>} TOTAL_CHARGE_AMT)

[arusanah]

this doesn't seems to work either

[joseduque]

Hi,

Null values are kinda tricky but you can read this article:

https://community.qlik.com/docs/DOC-3155

I'll also recommend you add value to null maybe a '-' This way you can do the set analysis like this

Sum({<[Charge ID]-={"-"}, REVENUE_DATE={"<= $([REPORT DATE]) "}>} TOTAL_CHARGE_AMT)

Hope this helps

Jose

[sunny_talwar]

What is the output that you are expecting to see?

[arusanah]

[sunny_talwar · Accepted solution]

How about this

Sum({<[Patient Charge ID] ={"*"}, TOTAL_CHARGE_AMT = {">0"}>} TOTAL_CHARGE_AMT)

[arusanah]

As always you are my life savor !!! thank you so much

[sunny_talwar]

Not always, but I try

[arusanah]

Thank you jose ,even this with additional condition works now .