Set Analysis Expression / quarter conditionality

RobinB1 — Sun, 04 Apr 2021 12:35:05 GMT

Hi,

I’m trying to dynamically get forecast data for all months after next quarter, with previous month as standpoint.

E.g. now, previous month was in Q1, hence I would want data for YearMonth 202107 forward.

Feels like I need some conditionality here but I don’t know how to do that in this syntax, i.e.:

if Month(Today()) is 2, 3 or 4 then return summed months from current year month 7 forward

if Month(Today()) is 5, 6 or 7 then return summed months from current year month 10 forward

if Month(Today()) is 8, 9 or 10 then return summed months from next year month 1 forward

if Month(Today()) is 11, 12 or 1 then return summed months from next year month 4 forward

I have fields Quarter and YearQuarter like (Q1, Q2, Q3, Q4) and (2021Q1, 2021Q2…) but I don’t think I can use Date(Today()) with those? I mean something like:

=Sum({<YearMonth ={">=$(=YearQuarter(Date(Today(),'YYYYMM')-1)+2)"},>}kWh)/Volume

Cheers,

Robin

topic Set Analysis Expression / quarter conditionality in QlikView

Set Analysis Expression / quarter conditionality