Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please help me with the following requirement.
YEAR | EMPID | |
---|---|---|
2016 | GIS11 | |
2016 | GIS12 | |
2016 | GIS13 | |
2017 | GIS12 | |
2017 |
| |
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.
Try in a text box, like:
=Concat(DISTINCT {<EMP={"=Count(distinct YEAR)=Count(Total distinct YEAR)"}>}EMP, ',')
How you want to show output?
Can you explain in detail?
Try in a text box, like:
=Concat(DISTINCT {<EMP={"=Count(distinct YEAR)=Count(Total distinct YEAR)"}>}EMP, ',')
We need to show the common EMPID for all the years in a text box.
Thank you Tresesco and Arjun rao...It's working Perfectly.
Thank you so much for your solution.It's working.
Please close the thread by marking 'Correct' : Qlik Community Tip: Marking Replies as Correct or Helpful