Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

dmac1971
Contributor II

# Days Target Hit

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.

1 Solution

Accepted Solutions
MVP
MVP

Re: # Days Target Hit

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

4 Replies
MVP
MVP

Re: # Days Target Hit

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
Valued Contributor III

Re: # Days Target Hit

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
Contributor II

Re: # Days Target Hit

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

dmac1971
Contributor II

Re: # Days Target Hit

That hit the nail on the head perfectly, thanks!

Community Browser