Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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