topic Re: Count if... in QlikView

Count if...

Fri, 15 Feb 2013 13:48:52 GMT

Hi guys im in need of some help here.

I am building a bar chart and want to display two things, tasks that are ontime and tasks that are overdue.

I am using this for ontime and it seems to work ok and give me the right number.

=COUNT(IF(CLOSED_DATE <= DEADLINE_DATE AND CLOSED_TIME <= DEADLINE_TIME,1))

However when i want to calculate the overdue tasks and use this

=COUNT(IF(CLOSED_DATE >> DEADLINE_DATE AND CLOSED_TIME >> DEADLINE_TIME,1))

...it doesnt seem to work correctly.

If anyone can tell me where i am going wrong i would be very greatful.

Thanks in advance.

Re: Count if...

Anonymous — Fri, 15 Feb 2013 14:16:45 GMT

Greater than is just one angled bracket ....

=COUNT(IF(CLOSED_DATE > DEADLINE_DATE AND CLOSED_TIME > DEADLINE_TIME,1))

Jonathan

Re: Count if...

manideep78 — Fri, 15 Feb 2013 14:41:43 GMT

greater than symbol is one angular brace not two angular braces.

use '>' instead of '>>'

Re: Count if...

jagan — Fri, 15 Feb 2013 14:45:21 GMT

Hi,

Try this expression using Set analysis, since If is a costlier operation.

=Sum({<CLOSED_DATE={'>DEADLINE_DATE AND CLOSED_TIME'} * {'>DEADLINE_TIME' >} 1)

Hope this helps you.

Regards,

Jagan.

Re: Count if...

manideep78 — Fri, 15 Feb 2013 14:52:26 GMT

Try this,

Count({<CLOSED_DATE={">DEADLINE_DATE"},CLOSED_TIME={">DEADLINE_TIME"}>}1)

Re: Count if...

Fri, 15 Feb 2013 15:11:55 GMT

Neither of those seem to work 😕 i get 1 regarless of how many Tasks there are.

Re: Count if...

Anonymous — Fri, 15 Feb 2013 21:42:39 GMT

So the problem with your expression is you will only hit true if both the deadline date and deadline time are greater. You are not counting records that were closed on the deadline date after the deadline time. Make sense?

You should do a few if checks

closed_date >= deadline_date AND closed_time > deadline_time

closed_date > deadline_date

I don't have QV handy but try

=COUNT(IF((CLOSED_DATE >= DEADLINE_DATE AND CLOSED_TIME > DEADLINE_TIME) OR (CLOSED_DATE > DEADLINE_DATE),1))

Re: Count if...

Anonymous — Sat, 16 Feb 2013 18:10:09 GMT

Hi,

can you please provide test data.

Regards