Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Show table of users who bought X but not Y

Hi!

I have a simple database with a table of purchases by a bunch of users. Some users bought more than one product (at different times).

I would like to build an interface where the Qlik Sense user can easily select products and generate a table showing the users who bought or did not buy those products. Ideally, I would like to have two list boxes, where the user can select products X and Y respectively, and the table updates to show what users bought X but not Y.

A think I know how to write set expressions to filter out the group of users I want. It also seems possible (although a bit clumsy) to use nested only() and aggr() functions as a calculated dimension, to use this set expression in a table. But how do I define X and Y from the user interface?

Or are there better ways to do these kind of things in Qlik Sense?

Cheers