topic Re: Sum if with multiple acceptable ifs in QlikView

Sum if with multiple acceptable ifs

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

I'm trying to use a sum if where I want it to accept multiple values to sum on, but I'm guessing my syntax is wrong as I'm not getting the value I'd like

Here's what it looks like

Sum(if([YearQuarter]='2017Q3', if([YearQuarter]='2017Q4', if([YearQuarter]='2018Q1', if([YearQuarter]='2018Q2',Reg90Inc)))))

What is the proper way to write this sum?

Re: Sum if with multiple acceptable ifs

kenkuchana — Tue, 17 Jul 2018 20:46:20 GMT

Sum({< [YearQuarter]={'2017Q3','2017Q4',’2018Q1',’2018Q2’}>} Reg90Inc)

Re: Sum if with multiple acceptable ifs

el_aprendiz111 — Tue, 17 Jul 2018 21:01:03 GMT

Hi,

1-option:

=if(WildMatch(YearQuarter,'2017Q1','2017Q2','2017Q3','2017Q4'),SUM(Reg90Inc),0)