Count of Task for Previous workday date

[DipeshVadgama]

Hi,

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

Started	Task
25569.04167	12
42853.48416	13
42853.48419	19
42857.88868	10
42857.88909	15
42857.89707	15
42857.89708	11
42857.89719	11

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]

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

Only - chart function ‒ QlikView

https://community.qlik.com/docs/DOC-8146

[Ralf_Heukäufer]

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]

May be this

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

[vishsaggi]

Why we need Total in the Max() Sunny?

[sunny_talwar]

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

[vishsaggi]

Got it. Cool.

[DipeshVadgama · Accepted solution]

Thanks all,

I have applied below syntax and its works perfect

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