Qlik Sense App Development

Contributor

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.

1 Solution

Accepted Solutions
MVP

Re: set analysis fro not null values

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

10 Replies
MVP

Re: set analysis fro not null values

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

Contributor

Re: set analysis fro not null values

this doesn't seems to work either

New Contributor III

Re: set analysis fro not null values

Hi,

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

MVP

Re: set analysis fro not null values

What is the output that you are expecting to see?

Contributor

MVP

Re: set analysis fro not null values

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

Contributor

Re: set analysis fro not null values

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

MVP

Re: set analysis fro not null values

Not always, but I try

Contributor

Re: set analysis fro not null values

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