Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

smiling_cheetah
New Contributor III

Selection NOT values (using AND logic)

Hello everyone, I came across the following task and cant quite figure it out, would appreciate any help

So there's a transaction table like:

ID TransactionOther fiels
1
2
3
4
5

Then each transaction has 1 or >1 attributes (stored in another table

ID TransactionAttribute
1q1
1q2
1q3
2q1
2q3
2q4
3q1
3q4
4q1
5q5

The task is to create a tool for selection Transactions which does NOT have a certain set of attributes. So to say, if I select "No q1", I see only ID Transaction = 5. Moreover, if I select "No q4" and "No q5", they work on AND logic, so I see only Transactions ID = {1, 4, 5}.

I came across following solution:

join flags to Transactions table like that, and then made 5 different filters in the interface

ID TransactionNoQ1FlagNoQ2FlagNoQ3FlagNoQ4FlagNoQ5FlagOther fields
111
211
3111
41111
51111

The only problem is that there could by a LOT of those attributes, and it seems like bad design to make a button for each of them.

Is there any chance I can do this differently?

Tags (1)
Community Browser