Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Awesome. As long as you were able to sort it out, its great.
Best,
S
Ciao Friend- try this expression =count({<RC={'D','K'}, Status={"*"}>-<RC={'D','K'}, Status={1}>} ID).
Hope it helps.
Thank you Friend, I tried that sentence but it did not throw me the same result as the script solution.
Regards
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.