set analysis

[thannila]

Please help me with the following requirement.

YEAR	EMPID
2016	GIS11
2016	GIS12
2016	GIS13
2017	GIS12
2017	GIS13
2018	GIS10
2018	GIS12
2018	GIS13

My output should be:

GIS12

GIS13

(i.e) GIS12 and GIS13 is common in all the year.

Note:Not only for above 3 years.It should work if any year is added additionally.

using set analysis concepts.

[qlikviewwizard]

How you want to show output?

Can you explain in detail?

[tresesco · Accepted solution]

Try in a text box, like:

=Concat(DISTINCT {<EMP={"=Count(distinct YEAR)=Count(Total distinct YEAR)"}>}EMP, ',')

[thannila]

We need to show the common EMPID for all the years in a text box.

[qlikviewwizard]

Hi Than Mughi,

Did you try tresesco solution?

[thannila]

Thank you Tresesco  and  Arjun rao...It's working Perfectly.

[thannila]

Thank you so much for your solution.It's working.

[tresesco]

Please close the thread by marking 'Correct' : Qlik Community Tip: Marking Replies as Correct or Helpful