SET ANALYSIS

thannila — Wed, 25 Nov 2020 16:16:04 GMT

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.

topic SET ANALYSIS in QlikView