Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Aggregate Count by Date

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:

fig1.PNG  fig2.PNG

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.

fig3.PNG

I attach the QS App in here.

Thanks in advance for the help!

Pablo

1 Reply
sunny_talwar

Is this what you want?

Capture.PNG

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