Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Ritvik
Contributor
Contributor

Compare 2 column and print the 3rd value in set analysis

I have 2 column Birthday_Month(Includes only month of employee birthdate) and 2nd column Pmonth(includes Present month) 
I need to compare both and give output The name of Employee(Firstname)

I tried using this but this is giving the number that only 1 person Have Birthday But i need Name to be printed

Count({<EmployeeID={"=(Birthday_Month=Pmonth)"}>}FirstName) 

Please help 

Thanks in advance 

Labels (2)
4 Replies
vinieme12
Champion III
Champion III

try 

Dimension

=aggr(if(Birthday_Month=Pmonth,EmployeeID),EmployeeID)  << uncheck include null values for this dimension

=Firstname

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Ritvik
Contributor
Contributor
Author

No its Not working

 

Ritvik
Contributor
Contributor
Author

No its not working

 

vinieme12
Champion III
Champion III

Dimension

=aggr(if(Birthday_Month=Pmonth,EmployeeID),EmployeeID) << uncheck include null values for this dimension

Measure 

=Maxstring(Firstname)

 

Or

 

Dimension

=EmployeeID 

Measure 

=if(Birthday_Month=Pmonth, FirstName)

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.