Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor

SET ANALYSIS

Hi ,

I have attached a excel sheet with data that contains two fields

                     DATE

                     EMPID

In this data,i need output like

      

                    For 2016,it should display all EMPID.

                    For 2017,display the EMPID not in both 2016 and 2017.

                    For 2018,display the EMPID not in both 2017 and 2018.



using set analysis chart function.


My output should be:

If i click the year 2016-it will display all EMPID.

If i click the year 2017-it should display EMPID

 

GIS011

GIS012

i.e the year which is not in 2017 but in 2016

If i click the year 2018-it should display EMPID

 

GIS012

GIS016

GIS017

i.e the year which is not common in 2017 and 2018.

Anyone help me to give solution.