-
Re: Null dimension in table due to set analysis
Sunny Talwar Apr 4, 2018 6:20 PM (in response to Michael Granillo)What exactly are you trying to do and what is that you expect to happen?
-
Re: Null dimension in table due to set analysis
Michael Granillo Apr 4, 2018 8:19 PM (in response to Sunny Talwar )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 Talwar Apr 4, 2018 8:55 PM (in response to Michael Granillo)-
Re: Null dimension in table due to set analysis
Digvijay Singh Apr 4, 2018 9:40 PM (in response to Sunny Talwar ) -
Re: Null dimension in table due to set analysis
Michael Granillo Apr 4, 2018 10:55 PM (in response to Sunny Talwar )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
Sunny Talwar Apr 5, 2018 5:04 AM (in response to Michael Granillo)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
Michael Granillo Apr 16, 2018 2:48 PM (in response to Sunny Talwar )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
-
-
-
-
-