10 Replies Latest reply: May 14, 2018 1:45 PM by Archana handu

# set analysis fro not null values

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.

• ###### Re: set analysis fro not null values

How about this

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

• ###### Re: set analysis fro not null values

this doesn't seems to work either

• ###### Re: set analysis fro not null values

What is the output that you are expecting to see?

• ###### Re: set analysis fro not null values

How about this

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

• ###### Re: set analysis fro not null values

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

• ###### Re: set analysis fro not null values

Not always, but I try

• ###### Re: set analysis fro not null values

keep up the Good work Sunny. I really appreciate all your help and I guess so does rest of qliker's.

• ###### Re: set analysis fro not null values

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

• ###### Re: set analysis fro not null values

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