topic Problem with counting by date in QlikView

Problem with counting by date

Wed, 10 Feb 2010 11:40:31 GMT

Hi all,

I have an application in which I would like to count IDs for every day in the data. When I try to do this it doesn't group correctly as the dates are duplicated. So you see the count like this:

1/8/2010 11
1/8/2010 2
1/8/2010 16

While I would expect

1/8/2010 29

Any ideas on how to do this?

Regards,

Rishi

Problem with counting by date

lironbaram — Wed, 10 Feb 2010 12:02:38 GMT

your problem is that the filed

Resource Start Date is a time stamp not a date , you see the same date repeating for every hour it have a record

attach is a solution in the chart, but you beter do this in the load script

you can use the same formula or just the simple one date(Resource Start Date)

hope it helps

Problem with counting by date

Wed, 10 Feb 2010 14:13:23 GMT

Hi RoiUser,

Thank a lot for the solution. You saved me a lot of time figuring out why it didn't group!

Keep up the good work!

Regards,

Rishi