Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can someone fix the null dimension, key2 field in this test app? or at least tell me why it doesn't work. The numbers are correct.
May be try this
What exactly are you trying to do and what is that you expect to happen?
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.
May be try this
Or may be 3rd expression like this -
Sunny this seems to work. Can you explain how this works? i've seen you do this before and never asked.
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
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