-
Re: Null dimension in table due to set analysis
What exactly are you trying to do and what is that you expect to happen?
-
Re: Null dimension in table due to set analysis
Thanks for trying to help. Maybe i'm way over complicating this. I have a 1 or 0 indicator but the indicator can be both 1 and 0 for a given dim. For example in the attached qvf for dim = c and dim = f the indicator is both 1 and 0. I want to count the dim when it's only 1. I want to count the dim when it's only 0. And I want the dim when it's 1 and 0. So my expression is calculating correctly but the dimension isn't associating correctly. Here's the final result I'd like to get.
-
-
-
Re: Null dimension in table due to set analysis
Sunny this seems to work. Can you explain how this works? i've seen you do this before and never asked.
-
Re: Null dimension in table due to set analysis
For the first one my search string is just counting only those dim where ind = 1... this works because if ind have more than 1 values, ind will essentially be null... (remember Only(ind) is ind))
Same, is true for ind = 2... and do you need to understand why the last one worked? that should be straight forward I think... but let me know if you still need help with it
-
Re: Null dimension in table due to set analysis
Thank you both for your responses. Both were helpful and got my issue solved. And I'm all good on the last one thanks!
Mike
-
-
-
-
-
