topic Re: Date function in QlikView

Date function

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

Hi,

I need to condier the data after 1/12/14.

So i have given his in the expression as

CDTS_DATE is in the format of MM/DD/YYY.

iTS NOT TAKING THE PERIOD CORRECTLY.Please let me know whats wrong in the below expression

=IF(NUM(CDTS_Date) > NUM(DATE(MAKEDATE(2014,01,12),'MM/DD/YYYY')),$(vCFS)

-Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'},CALL_TYPE={'SPECIAL'},CALL_SUB_TYPE={'OIL'}>}EID)-

Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'},CALL_TYPE={'STATION'}>}EID))

Thanks,

Re: Date function

sunny_talwar — Tue, 23 Aug 2016 11:17:16 GMT

How about this:

=If(CDTS_Date > MakeDate(2014,1,12),

$(vCFS)

- Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'},CALL_TYPE={'SPECIAL'},CALL_SUB_TYPE={'OIL'}>}EID)

- Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'},CALL_TYPE={'STATION'}>}EID))

Re: Date function

bhavvibudagam — Tue, 23 Aug 2016 11:32:07 GMT

Hi Sunny,

Not getting.Please find the attachment of cdts date format.

Have taken the CDTS_DATE Field from CDTS.

Re: Date function

sunny_talwar — Tue, 23 Aug 2016 11:34:56 GMT

Do you have CDTS_Date as your dimension? If not, then try using set analysis or if statement within the Count function

Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'},CALL_TYPE={'SPECIAL'},CALL_SUB_TYPE={'OIL'}>} If(CDTS_Date > MakeDate(2014,1,12), EID))

Count({<CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'},CALL_TYPE={'SPECIAL'},CALL_SUB_TYPE={'OIL'}, CDTS_Date = {"$(='>' & Date(MakeDate(2014,1,12), 'MM/DD/YYYY'))"}>} EID)

Re: Date function

bhavvibudagam — Tue, 23 Aug 2016 11:45:51 GMT

Yes working fine Thank you

Re: Date function

sunny_talwar — Tue, 23 Aug 2016 11:47:05 GMT

Awesome