# Days Target Hit

[dmac1971]

I have a variable that contains my daily target for # completed tasks, say vTarget, and I want to count the number of days I have hit this target, counting the number of tasks complete.  Cant figure this out in my head though!!  Grrr.

[Oleg_Troyansky · Accepted solution]

Something like this:

count( {<Date={"=count(distinct Task)>=$(vTarget)"}>}  distinct Date)

You are counting Dates that satisfied the Advanced Search condition, in which the distinct count of Tasks (per Date) should be greater or equal than the target.

You may need to tweak this logic for your data.

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

[ramoncova06]

you need to provide a little more of information, are you doing this in a table, graph or a text object ?

what expression are you using ?

[dmac1971]

Sorry it will be in a text object, ie a simple statement.

[dmac1971]

That hit the nail on the head perfectly, thanks!