Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

lookup/countif

Hi, I dont know how and have been trying to add a calculated field to show if a phone number is present in another table in order to apply a group to it. 

the excel formula can be one of these two: =if(vlookup(A1,'sheet2'A:B,2)=0,"present","not present")

or =if(countif(A1,'sheet2'B1:B30)=0,"not present","present")

 

i dont mind either method, i just need to assign a grouping to the phone number depending if it is present on a separate list - shown as sheet 2 in the example

Thanks in advance for your help!