Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

May i know how to add filter year > 2010 in none SET expression ?

Hi All

May i know how to add filter year > 2010 in to below expression ?

Sum(DISTINCT {<COMPETITOR = {'WAGO', 'iTDS'}>} REVENUE_C)

Paul

1 Solution

Accepted Solutions
sunny_talwar

Paul, these are some easy set analysis problem. Are you having trouble in implementing set analysis? I recommend looking at this document to gain some understanding of set analysis

View solution in original post

6 Replies
paulyeo11
Master
Master
Author

my QV Doc

sunny_talwar

May be this:

Sum(DISTINCT {<COMPETITOR = {'WAGO', 'iTDS'}, year = {'>=2010'}>} REVENUE_C)

tamilarasu
Champion
Champion

Try,

Sum(DISTINCT {<COMPETITOR = {'WAGO', 'iTDS'}, year={'>2010'}>} REVENUE_C)

sunny_talwar

Paul, these are some easy set analysis problem. Are you having trouble in implementing set analysis? I recommend looking at this document to gain some understanding of set analysis

paulyeo11
Master
Master
Author

Hi sunny

I will read thru , thank you

Paul

BinayKumarSah
Contributor III
Contributor III

Thanks for sharing the docs. Its really helpful