topic Re: Count of Task for Previous workday date in QlikView

Count of Task for Previous workday date

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

Hi,

I am trying to calculate count of task for previous workday data. I have my data in below format

I am trying to apply

Count({$<Started={"$(=Date(only(Started)-1))"}>}Task) but no result

I did try to convert Started to Date(Started) in load but no use.

Anil_Babu_Samineni — Thu, 09 Nov 2017 14:59:04 GMT

You may need to understand the Only() function and how this works.

Ralf_Heukäufer — Thu, 09 Nov 2017 15:02:20 GMT

Hello Dipesh,

for the count you can try

=aggr(count(Task),Started)

But what is the format of the started date?

If it is a timestamp you must use the timestamp() funktion instead of date:

In the case that are two dates seperatet by a point you must build a substring.

sunny_talwar — Thu, 09 Nov 2017 15:39:18 GMT

May be this

Count({$<Started={"=Floor(Started) = (Max(TOTAL Floor(Started))-1)"}>}Task)

vishsaggi — Thu, 09 Nov 2017 15:47:47 GMT

Why we need Total in the Max() Sunny?

sunny_talwar — Thu, 09 Nov 2017 15:51:30 GMT

Because Max(Floor(Started)) = Floor(Started) when Started is the dimension.... to get the Max across all Started... we need TOTAL

vishsaggi — Thu, 09 Nov 2017 16:38:31 GMT

Got it. Cool.

DipeshVadgama — Fri, 10 Nov 2017 14:16:00 GMT

Thanks all,

I have applied below syntax and its works perfect

=Count({$<Started={'=Num(Floor(Started))= Num(firstworkdate(Today()-1, 1))'}>}Task)