Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
RKULKARNI4
Contributor III
Contributor III

Queries in dupicates

Hello Team,

 I have two requirement which i need to get it done.Please anyone can you guide me 

  • The resultset1 is one query table will contains all the fields and will do inner join with another table called Table2.I need to find only duplicates of the num1(Synd) based on Numer and date(From table2 and resultset1 section)
  • The resultset1 is one query table will contains all the fields and will do inner join with another table called Table2.I need to find only non duplicates of the num1(Synd) based on Numer and date(From table2 and resultset1 section)

     Note : The field num1(Synd) is present in both resultset1 and table2 .

 

  Please advise 

Thanks in advance

 

Regards

RK

 

2 Replies
PrashantSangle

can you explain with sample data? with desired output?

Great dreamer's dreams never fulfilled, they are always transcended.
RKULKARNI4
Contributor III
Contributor III
Author

Please refer the attachment

 

Regards

RK