topic SUMIF Date >= in QlikView

SUMIF Date >=

cmutombo — Fri, 22 Jan 2021 11:35:41 GMT

Hi People,

Look this formula : Give me : Sum of VOICE REVENUE of 01 Jan 2021 (Formula is working correctly)

=num(((Sum({$<[DATE_]={"$(=timestamp(MonthStart(date(today()-1))))"},SERVICE={'VOICE'}>}REVENUE))/1.26)/1000,'0.0')

But, I am Looking for good syntax to have :

Sum of VOICE REVENUE of All Dates > = 01 Jan 2021 (From 01 Jan 2021 to 21 Jan 2021)

regards,

PriyankaShivhare — Fri, 22 Jan 2021 11:52:07 GMT

create a flag for MTD in load script calendar

if (Month(Date_)=Month(today()) ,1) as MTD_Flag

=num(((Sum({$<MTD_Flag={1},SERVICE={'VOICE'}>}REVENUE))/1.26)/1000,'0.0')

Thanks,

Priyanka

cmutombo — Fri, 22 Jan 2021 15:44:36 GMT

Hi Mrs

Thank you for your feedback. But I found the best way below :

=num(((Sum({$<[DATE_]={">=$(=timestamp(MonthStart(date(today()-1))))"},SERVICE={'VOICE'}>}REVENUE))/1.26)/1000,'0.0')