topic Re: About formula COUNT if two conditions in QlikView

About formula COUNT if two conditions

cmutombo — Sun, 17 Jan 2021 18:33:51 GMT

Hi Community,

I have an issue of syntax with formula COUNT if two conditions. My formula is :

=Count({$<DocSource>}{$<POT={'Paid on Time'}>}{$<[MonthName(PaymentDate)]={"$(=MonthName(Today()))"}>}DocSource)

1. First condition is : POT ='Paid on Time'

2. Second condition is : MonthName(PaymentDate) = MonthName(Today())

But when I run, Only second condition is running. The first condition is ignored

Please help with the correct syntax

Thanks in advance.

Re: About formula COUNT if two conditions

MayilVahanan — Mon, 18 Jan 2021 08:00:51 GMT

Hi @cmutombo

Try like below

Count({<PaymentDate={">=$(=MonthStart(Today()))<=$(=MonthEnd(Today()))"},POT={'Paid on Time'}>}DocSource)

Re: About formula COUNT if two conditions

cmutombo — Thu, 21 Jan 2021 15:45:43 GMT

Thanks a lot MayilVahanan

regards,

Re: About formula COUNT if two conditions

cmutombo — Thu, 21 Jan 2021 17:09:51 GMT

Hi MayilVahanan

I come again to you with this formula :

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

For a sum if :

1. DATE_ = Yesterday

2. SERVICE = "VOICE"

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

Thanks in advance.

Re: About formula COUNT if two conditions

MayilVahanan — Fri, 22 Jan 2021 01:08:42 GMT

Hi @cmutombo

Might be, ur date format is different.

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

-- change ur date format respectively. And also, check whether u have data yesterday or not.

Please close the ticket by marking correct answer / like. so that, it helps other for similar issue.

Re: About formula COUNT if two conditions

cmutombo — Fri, 22 Jan 2021 07:13:59 GMT

Hi MayilVahanan

Yes, I have data in my data base

But, Qlik say : Errors in Expression :

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

I am agree with you to change Today() format.

regards,

Re: About formula COUNT if two conditions

cmutombo — Fri, 22 Jan 2021 08:20:13 GMT

MayilVahanan

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)

Re: About formula COUNT if two conditions

cmutombo — Fri, 22 Jan 2021 09:46:03 GMT

Hi MayilVahanan

this is the correct way

MANY THAAAANKS !!

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

Re: About formula COUNT if two conditions

MayilVahanan — Fri, 22 Jan 2021 09:49:29 GMT

Hi @cmutombo

Can you close the thread by marking correct answer..

Re: About formula COUNT if two conditions

cmutombo — Fri, 22 Jan 2021 09:52:15 GMT

Yes, I can, But how to do it ?