topic Re: set analysis in QlikView

set analysis

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

Please help me with the following requirement.

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.

Re: set analysis

qlikviewwizard — Wed, 04 Jul 2018 06:36:30 GMT

How you want to show output?

Can you explain in detail?

Re: set analysis

tresB — Wed, 04 Jul 2018 06:39:20 GMT

Try in a text box, like:

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

Re: set analysis

thannila — Wed, 04 Jul 2018 07:11:15 GMT

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

Re: set analysis

qlikviewwizard — Wed, 04 Jul 2018 07:40:25 GMT

Hi Than Mughi,

Did you try tresesco solution?

Re: set analysis

thannila — Wed, 04 Jul 2018 07:54:33 GMT

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

Re: set analysis

thannila — Wed, 04 Jul 2018 07:55:58 GMT

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

Re: set analysis

tresB — Wed, 04 Jul 2018 08:38:53 GMT

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