Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mgranillo
Specialist
Specialist

Null dimension in table due to set analysis

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.

1 Solution

Accepted Solutions
sunny_talwar

7 Replies
sunny_talwar

What exactly are you trying to do and what is that you expect to happen?

mgranillo
Specialist
Specialist
Author

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.

Capture.PNG

sunny_talwar

May be try this

Capture.PNG

Digvijay_Singh

Or may be 3rd expression like this -

Capture.PNG

mgranillo
Specialist
Specialist
Author

Sunny this seems to work.  Can you explain how this works? i've seen you do this before and never asked. 

sunny_talwar

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

mgranillo
Specialist
Specialist
Author

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