topic Re: Find the count based on date condition. in QlikView

Find the count based on date condition.

Anonymous — Fri, 16 Feb 2018 13:13:45 GMT

Hi All,

lastUpdatedDate Count(id)

14/02/2018 02:12:00 AM 35

14/02/2018 02:37:00 AM 48

13/02/2018 12:45:00 AM 44

13/02/2018 03:54:00 AM 34

i need the count only for 14th of Feb but i get the count of 14th and 13th as well. I used the below script to do this. But not getting the count of 83 only for 14th.

Count({<lastUpdatedDate = {"=$(=Date(Today()-1))"}>} id)

How to achieve the count only for 14th Feb??

Re: Find the count based on date condition.

sunny_talwar — Fri, 16 Feb 2018 16:35:53 GMT

First of all, you have a timestamp which cannot be directly equated to a date field...( you can use search string, but why not fix this in the script)

LOAD lastUpdatedDate as TimeStamp,

Date(Floor(lastUpdatedDate)) as lastUpdatedDate

....

FROM ...;

Now try this

Count({<lastUpdatedDate = {"$(=Date(Today()-1))"}>} id)

Alternatively, you can use a search string like this

Count({<lastUpdatedDate = {"=Floor(lastUpdatedDate) = Today()"}>}id)

But, again, I would suggest to use the first method over the second one because there is some more evaluation required for the second one, where as first one is very straight forward.

Re: Find the count based on date condition.

Anonymous — Mon, 19 Feb 2018 14:18:00 GMT

Thank you Sunny

Re: Find the count based on date condition.

Anonymous — Tue, 20 Feb 2018 09:01:52 GMT

Also i need to add an and condition for the syntax Count({<lastUpdatedDate = {"$(=Date(Today()-1))"}>} id)

onlinePrice >=0 then id

I tried in many ways but my syntax is not getting correct. Could you please help me

Re: Find the count based on date condition.

sunny_talwar — Tue, 20 Feb 2018 09:59:47 GMT

May be this

Count({<lastUpdatedDate = {"$(=Date(Today()-1))"}, onlinePrice = {">=0"}>} id)

Re: Find the count based on date condition.

Anonymous — Tue, 20 Feb 2018 10:22:23 GMT

Thank you very much