Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Vishnu_murthy
Contributor
Contributor

set analysis

 i need which country are use the product both year(2000 and 2001) in set expression logic

 

year

Product

country

2000

P1

India

2000

P1

usa

2000

P1

uk

2001

P1

India

2001

P1

Usa

2001

P1

Uk

2001

P1

japan

Labels (2)
1 Reply
vinieme12
Champion III
Champion III

=count({<Country={"=count({<Year={'2020','2021'},Product={'P1'}>}distinct Year)=2"}>}Distinct Country)

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