topic Re: set analysis fro not null values in App Development

set analysis fro not null values

arusanah — Mon, 14 May 2018 16:33:48 GMT

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

sunny_talwar — Mon, 14 May 2018 16:39:13 GMT

How about this

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

Re: set analysis fro not null values

arusanah — Mon, 14 May 2018 16:43:12 GMT

this doesn't seems to work either

Re: set analysis fro not null values

joseduque — Mon, 14 May 2018 16:44:45 GMT

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

sunny_talwar — Mon, 14 May 2018 16:46:18 GMT

What is the output that you are expecting to see?

Re: set analysis fro not null values

arusanah — Mon, 14 May 2018 17:29:16 GMT

Re: set analysis fro not null values

sunny_talwar — Mon, 14 May 2018 17:32:02 GMT

How about this

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

Re: set analysis fro not null values

arusanah — Mon, 14 May 2018 17:41:07 GMT

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

Re: set analysis fro not null values

sunny_talwar — Mon, 14 May 2018 17:42:03 GMT

Not always, but I try

Re: set analysis fro not null values

arusanah — Mon, 14 May 2018 17:42:44 GMT

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

Re: set analysis fro not null values

arusanah — Mon, 14 May 2018 17:45:39 GMT

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

ysalvi43 — Thu, 04 Dec 2025 14:03:00 GMT

Hello

There might be possibility of null in the row because of which set analysis is not able to quantify the results. suggestion would be replace that null to NA or unknown and then use below formula.

formula: {<Product1 = {"NA"}>} Sum( Sales)

Thanks