We have this qlik view file that get the data from multiple source and creates a big list of emails that we use to make selections for sending newsletters.
And exaple of selection would be:
All the teachers including all people from one city.
To obtain this we now use these 2 methods:
we export 2 separate excel based on each selection
use a method like this
make the first selection and click a button that export a qlik file selection1.qvo
make the second selection and click a button that export a qlik file selection2.qvo
reload the document and populate a table with the 2 qlik files created before
We want to know if there is any solution to have, maybe with set analisys, a union of the selections made so we can directly have the data that we need without using excel to union and remove duplicates or have to reload the document.
Example of what we want:
make the first selection on profession field
make the second selection on country field
have a table with the union of these 2 selections ready to be exported