topic Re: Count Registers By Date in QlikView

Count Registers By Date

Anonymous — Tue, 19 Apr 2016 20:13:56 GMT

Hello,

I have the next fields:

Date, Field1 and Field2 (not Count)

And I need a table like that:

The issue is that I dont have the field count in my data model.

Is it possible somehow build a table like this without calculate this count field in the script?

Thank you,

Sara

Re: Count Registers By Date

sunny_talwar — Tue, 19 Apr 2016 20:47:38 GMT

May be create the Count field like this:

LOAD Date,

Field1,

Field2,

AutoNumber(Field1, Date) as Count

FROM Source;

LOAD Date,

Field1,

Field2,

AutoNumber(Field1&Field2, Date) as Count

FROM Source;

Re: Count Registers By Date

Anonymous — Tue, 19 Apr 2016 21:07:54 GMT

Thank you, It works. But there is another way to build this table without scripting?

Re: Count Registers By Date

sunny_talwar — Tue, 19 Apr 2016 21:47:56 GMT

You can probably add a calculated dimension, but will have to test it out. Can you share a sample?

Re: Count Registers By Date

sunny_talwar — Tue, 19 Apr 2016 22:02:39 GMT

Try this as dimension:

=Aggr(RowNo(), Date, Field1)

Re: Count Registers By Date

Anonymous — Tue, 19 Apr 2016 22:04:21 GMT

I attached the qvw example. Thank you.

Re: Count Registers By Date

sunny_talwar — Tue, 19 Apr 2016 22:40:25 GMT

I assume this was in moderation and just went through? The issue is resolved right?

Re: Count Registers By Date

Anonymous — Wed, 20 Apr 2016 07:52:48 GMT

That was it. Thank you

Re: Count Registers By Date

Anonymous — Thu, 21 Apr 2016 09:48:40 GMT

Hello,

One doubt, my real data model contains dates with hours, I try with that :

=Aggr(RowNo(), floor([Date]), Field )

But it doesnt work.

Thanks

Re: Count Registers By Date

sunny_talwar — Thu, 21 Apr 2016 15:01:28 GMT

There could be another issue unrelated to the date field. Not sure what it can be without take a look. Can you share a more comprehensive sample where it isn't working?

Re: Count Registers By Date

Anonymous — Tue, 26 Apr 2016 21:07:23 GMT

Hello,

I attached the example with date with hours. The issue is that with the aggr function I am no able to use a calculated dimension (floor function).

Thank you

Sara

Re: Count Registers By Date

sunny_talwar — Tue, 26 Apr 2016 23:00:44 GMT

Yes, Aggr() function doesn't allow for using calculated dimensions. It is a problem. Would it not be possible to create a new field without the time component using the floor function?

Are you trying to have sequence of numbers for a each particular day?

Re: Count Registers By Date

Anonymous — Wed, 27 Apr 2016 07:48:03 GMT

It is not possible to create a new field with the field without the time. And yes, I am trying to have a sequenece of numbers of each particular day.

thank you