Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
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 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:
Maybe i found the way!
Using this exaple :https://community.qlik.com/t5/QlikView-App-Development/Alternate-States-using-scatter-chart-Selectio...
i have made a chart table and use the dimension EMAIL and an expression with =Count(DISTINCT {[sel1]} EMAIL) + Count( DISTINCT {[sel2]} EMAIL)
I have to control that is everything ok but this seems the final solution
maybe on way would be to use 2 alternate states. but how do i union data from the 2 alternate states in a table?
Maybe i found the way!
Using this exaple :https://community.qlik.com/t5/QlikView-App-Development/Alternate-States-using-scatter-chart-Selectio...
i have made a chart table and use the dimension EMAIL and an expression with =Count(DISTINCT {[sel1]} EMAIL) + Count( DISTINCT {[sel2]} EMAIL)
I have to control that is everything ok but this seems the final solution