Aggregate Count by Date

Anonymous — Tue, 08 May 2018 11:10:33 GMT

Hi community.

I am trying to achieve a simple transformation of data to enhance visualization in a table. I can easily reproduce it in Excel but it is being really tough in QS.

The transformation is this one:

I just want to count the number of times each class appear per date, and compute the rate of occurrences per date.

I am trying to accomplish this with a Table and a Pivot Table, but with any of them I success:

In the case of the table, I am able to get the nominator and denominator by =Aggr(Count(Class), Date). But I can't compute the division as =Count(Date)/Aggr(Count(Class), Date) because I get 'INVALID DIMENSION'

In the case of the pivot table, I just receive the output for 1 class per Date, and QS is ignoring the rest of the classes.

I attach the QS App in here.

Thanks in advance for the help!

Pablo

Re: Aggregate Count by Date

sunny_talwar — Tue, 29 May 2018 16:34:37 GMT

Is this what you want?

Count(Class)/Aggr(NODISTINCT Count(Class), Date)

topic Aggregate Count by Date in QlikView

Aggregate Count by Date

Re: Aggregate Count by Date