Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
sebastianalin
New Contributor II

Table/chart with data in union from selections

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:

  1. we export 2 separate excel based on each selection 
  2. 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:

  1. make the first selection on profession field
  2. make the second selection on country field
  3. have a table with the union of these 2 selections ready to be exported
1 Solution

Accepted Solutions
sebastianalin
New Contributor II

Re: Table/chart with data in union from selections

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

2 Replies
sebastianalin
New Contributor II

Re: Table/chart with data in union from selections

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

 

sebastianalin
New Contributor II

Re: Table/chart with data in union from selections

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