topic Re: Count is not matching ! in QlikView

Count is not matching !

Fri, 09 Jun 2017 07:52:37 GMT

Hi,

Actually I am running this script in SQL server ,

select branch, count(ID)

FROM XYZ where (date(Field1)+day(15)) <= GETDATE() group by branch

This is my Qlikview expression :

=Count(If((Date(Field1) + 15) <= DATE(now()),ID)

Both are giving different counts.

Also TODAY() function doesn't gives today's date in Qlikview.

MK_QSL — Fri, 09 Jun 2017 07:58:21 GMT

Check for Today(0), Today(1) and Today(2)

antoniotiman — Fri, 09 Jun 2017 08:03:46 GMT

As You have Group By in script,

may be you need Aggr(...,branch) and optionally DISTINCT

Regards,

Antonio

Fri, 09 Jun 2017 09:23:30 GMT

I think no need of AGGR() bcoz I am using Branch as a list box.

Today(0), Today(1) and Today(2): Gives same count as before.

sunny_talwar — Fri, 09 Jun 2017 09:34:43 GMT

May be try this

Count(DISTINCT {<Field1 = {"$(='<=' & Date(Today() - 15))"}>} ID)

Where check that =Date(Today() - 15) gives the date you are looking for and in the format of Field1 date field.

UPDATE: Added '<=' & to fix my expression to look at Field1 where is it less than or equal to Today()-15

pipuindia99 — Fri, 09 Jun 2017 12:06:18 GMT

Count(DISTINCT {<Field1 = {"$(=Date(Today() - 15))"}>} ID) what Sunny said looks correct to me as well