topic Re: # Days Target Hit in QlikView

# Days Target Hit

dmac1971 — Tue, 08 Sep 2015 14:56:01 GMT

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.

Re: # Days Target Hit

Oleg_Troyansky — Tue, 08 Sep 2015 15:02:08 GMT

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

Re: # Days Target Hit

ramoncova06 — Tue, 08 Sep 2015 15:02:22 GMT

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 ?

Re: # Days Target Hit

dmac1971 — Tue, 08 Sep 2015 15:03:02 GMT

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

Re: # Days Target Hit

dmac1971 — Tue, 08 Sep 2015 15:03:43 GMT

That hit the nail on the head perfectly, thanks!