topic Re: Table/chart with data in union from selections in QlikView

Table/chart with data in union from selections

sebastianalin — Tue, 02 Jul 2019 10:03:51 GMT

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 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

Re: Table/chart with data in union from selections

sebastianalin — Tue, 02 Jul 2019 12:58:42 GMT

maybe on way would be to use 2 alternate states. but how do i union data from the 2 alternate states in a table?

Re: Table/chart with data in union from selections

sebastianalin — Tue, 02 Jul 2019 13:13:06 GMT

Maybe i found the way!

Using this exaple :https://community.qlik.com/t5/QlikView-App-Development/Alternate-States-using-scatter-chart-Selections/td-p/710846

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