topic Re: SUMIF issue in QlikView

SUMIF issue

cmutombo — Fri, 22 Jan 2021 08:22:24 GMT

Hi Community

I found the good format, but syntaxes issue still continue :

1. =Sum({$<date( date#(DATE_,'M/D/YYYY h:mm:ss TT','M/DD/YYYY'))= {"$(=Date(Today()-1))"},SERVICE={'VOICE'}>}REVENUE)

2. =Sum({$<[DATE_]= {"$(=date( date#(date(Today()-1), 'M/DD/YYYY') , 'M/D/YYYY h:mm:ss TT')"},SERVICE={'VOICE'}>}REVENUE)

Both of two are failed. May be for syntaxes (special characters)

Please Help

Re: SUMIF issue

rubenmarin — Fri, 22 Jan 2021 08:31:11 GMT

Hi @cmutombo, the first one doesn't has a correct synta, in set analysis yo have to use a field name in the left side of the '='.

The 2nd can work if DATE_ is the name of a real field loaded in data model. maybe you need to use Timestamp() and timestamp#(), or remove the time part of the date function.

Also check which avlue returns =date( date#(date(Today()-1), 'M/DD/YYYY') , 'M/D/YYYY h:mm:ss TT') (or using timestamp) and confirm that there is a value in DATE_ field that matchs that value.

Re: SUMIF issue

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

Hi rubenmarin

When i use the second, Message is "Error in set Modify ad hoc element in list..."

Re: SUMIF issue

cmutombo — Fri, 22 Jan 2021 09:43:31 GMT

Hi rubenmarin

This the correct way

MANY THAAAAAAAANKS !!!!!

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