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: 
Not applicable

Managing Mutually Exclusive Data

Hello! I need to present data in a table showing the total number of row records per column, but because some of the row data is mutually exclusive the data will only show the the row where the flag is enabled. This behavior is a result of the way in which the data is structured within the database record. So, if we visualize a bushel as the record, the bushel may only be filled with apples or oranges, but never both. As you may have guessed, this control is managed via a flag. So, when I ask to show all apples and oranges in this bushel, only one or the other is displayed in my table's current config. Is there a way to join rows from different tables, or a way to have this display use an "or" function rather than an "and"? Of course, I appreciate any other ideas you may have - thanks!

0 Replies