topic Can you merge the 2 set analysis expressions? in QlikView

Can you merge the 2 set analysis expressions?

aaronnayan — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys

Can you merge these two expressions if possible?

Into 1 expression

sum({$<ADVISORS={"JAMES"}>}SALES) + Sum({1<DEC_Month={'$(vCurrMth)'}>}SALES)

tresB — Thu, 17 Aug 2017 10:44:26 GMT

If you want to get the sum of them using one expression, try like:

using OR logic:

sum({$<ADVISORS={"JAMES"}> + <DEC_Month={'$(vCurrMth)'}>}SALES)

if you want both the condition to be true, try like:

using AND logic:

sum({$<ADVISORS={"JAMES"} , DEC_Month={'$(vCurrMth)'}>}SALES)

aaronnayan — Thu, 17 Aug 2017 10:54:15 GMT

Hi TResesco

Its not picking up the variable. I want it to calculate it using for the current month

Could you help?

tresB — Thu, 17 Aug 2017 11:00:16 GMT

If variable is an issue, try like:

DEC_Month={'$(=Month(Today()))'}

If the month format of your field matches with the format return by the expression, it should work.