Error in Calculation in Set Analysis Expression of a Pie Graph

[#1]

Good Morning Everyone, I have a problem in one pie graph where I have one set analysis expression to calculate a distribution by a given variable.

With this expression I create my first distribution where Status=1

count({<Rc={'D','K'}, Status={1}>} ID)

Here is the problem, with the following expression, I want to create a distribution with Status<>1, but sometimes Status could be Null. Then the expression does not consider this value, and I do not have all the registers.

count({<Rc={'D','K'}, Status-={1}>} ID)

Thanks for your help.

[sunny_talwar]

Awesome. As long as you were able to sort it out, its great.

Best,

S

[Anonymous]

Ciao Friend- try this expression =count({<RC={'D','K'}, Status={"*"}>-<RC={'D','K'}, Status={1}>} ID).

Hope it helps.

[#4]

Thank you Friend, I tried that sentence but it did not throw me the same result as the script solution.

Regards

[Anonymous]

Thanks for your reply. I have basically created a set that has all the data excluding null values and the another set which does not have values for status=1. Then I have subtracted second set from the first set that exclude null as well as 1 from the first set. I guess that’s what probably you wanted. Attached is the sample qvw and data set. Let me know if you wanna send your app, I can check what’s going wrong there.