topic Re: Multiple IF statement, with Set Analysis in QlikView

Multiple IF statement, with Set Analysis

marcus_steggall — Sat, 16 Nov 2024 04:09:21 GMT

Hi team,

If I was producing a calculation in line one below, that works perfectly when selecting 2017.

Say I wanted to add a second line into the calculation, based on another year how would this work?

This one below, doesn't work for me

=SUM({<Year_YYYY={'$(vMaxYear)'},Period_P=,Period_Start={"<=$(vMaxDate)"}>} if(Year_YYYY='2017' ,Revenue*1.09))
OR
SUM({<Year_YYYY={'$(vMaxYear)'},Period_P=,Period_Start={"<=$(vMaxDate)"}>} if(Year_YYYY='2018' ,Revenue*1.07))

Cheers for your advice

Re: Multiple IF statement, with Set Analysis

sunny_talwar — Fri, 15 Mar 2019 12:04:29 GMT

May be try this

=Sum({<Year_YYYY={'$(vMaxYear)'}, Period_P, Period_Start = {"<=$(vMaxDate)"}>}
  Revenue *
  Pick(Match(Year_YYYY, '2017', '2018') , 1.09, 1.07)
)

Re: Multiple IF statement, with Set Analysis

marcus_steggall — Fri, 15 Mar 2019 13:56:21 GMT

ahh genious, I like that way

very helpful Sunny, appreciate your help

have a great weekend