Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
RobinB1
Contributor
Contributor

Set Analysis Expression / quarter conditionality

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

0 Replies