Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

arusanah
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

Re: set analysis fro not null values

How about this

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

10 Replies

Re: set analysis fro not null values

How about this

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

arusanah
Contributor

Re: set analysis fro not null values

this doesn't seems to work either

joseduque
New Contributor III

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

What is the output that you are expecting to see?

arusanah
Contributor

Re: set analysis fro not null values

Re: set analysis fro not null values

How about this

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

arusanah
Contributor

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

arusanah
Contributor

Re: set analysis fro not null values

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

Community Browser