Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

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

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

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

5 Replies
paulyeo11
Valued Contributor II

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

my QV Doc

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

May be this:

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

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

Try,

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

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

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
Valued Contributor II

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

Hi sunny

I will read thru , thank you

Paul

Community Browser