Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
blunckc1
Not applicable

Set analysis help


Hi everyone,

I'm still getting my head around set analysis and I found the following set analysis expression which works great.

Sum({<MonthYear ={">=$(=date(addmonths(date#('$(vYearMonth)','MMM-YYYY'),-11),'MMM-YYYY')) <=$(=date#('$(vYearMonth)','MMM-YYYY'))"}, Year=,Month=>} Hours)

I need to however add another modifier to this and I have no clue how or where!  The modifier that needs to be added is bolded in this much more straight forward set analysis expression.

Sum({$<[Payment Type Category]={'Overtime'}>}Hours).

Can you someone please point me in the right direction?

Thank you!!

Tags (1)
1 Solution

Accepted Solutions
shraddha_g
Not applicable

Re: Set analysis help

Try

Sum({$<MonthYear ={">=$(=date(addmonths(date#('$(vYearMonth)','MMM-YYYY'),-11),'MMM-YYYY')) <=$(=date#('$(vYearMonth)','MMM-YYYY'))"}, Year=,Month=,[Payment Type Category]={'Overtime'}>} Hours)

2 Replies
shraddha_g
Not applicable

Re: Set analysis help

Try

Sum({$<MonthYear ={">=$(=date(addmonths(date#('$(vYearMonth)','MMM-YYYY'),-11),'MMM-YYYY')) <=$(=date#('$(vYearMonth)','MMM-YYYY'))"}, Year=,Month=,[Payment Type Category]={'Overtime'}>} Hours)

blunckc1
Not applicable

Re: Set analysis help

Mate, cheers the quick response.  Seems to work.  Legend.