topic Re: SUMIF in QlikView

SUMIF

cmutombo — Thu, 21 Jan 2021 17:12:10 GMT

Hi Community,

I come to you with this formula :

=Sum({$<[DATE_]= {"$(=Date(Today()-1))"},SERVICE={'VOICE'}>}REVENUE)

Sumifs:

1. DATE_ = Yesterday

2. SERVICE = "VOICE"

I don't have a good result. Is the syntax good ?

Thanks in advance.

edwin — Thu, 21 Jan 2021 19:09:27 GMT

try it with single quotes:

=Sum({$<[DATE_]= {'$(=Date(Today()-1))'},SERVICE={'VOICE'}>}REVENUE)

edwin — Thu, 21 Jan 2021 19:10:17 GMT

also make sure DATE_ field is the correct/default date format