Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Frequency distribution chart

Is there a way to plot the frequency distribution chart in Qlik Sense ?

For example:

Frequency:

LOAD *

INLINE [

  cr_id, date_added

  CR0,01/12/2014

  CR0,01/12/2014

  CR1,01/12/2014

  CR1,01/12/2014

  CR1,01/12/2014

  CR2,01/12/2014

  CR2,01/12/2014

  CR2,01/12/2014

  CR0,01/12/2014

  CR0,01/12/2014

  CR0,01/12/2014

  CR3,01/12/2014

  CR3,01/12/2014

  CR3,01/12/2014

  CR0,01/12/2014

  CR3,01/12/2014

  CR4,01/12/2014

  CR5,01/12/2014

  CR6,01/12/2014

  CR7,01/12/2014

  CR8,01/12/2014

  CR9,01/12/2014

  CR10,01/12/2014

  CR11,01/12/2014

  CR12,01/12/2014

  CR13,01/12/2014

  CR14,01/12/2014

];   

should produce this:

Clip3.png

I tried to use "class(aggr(count(cr_id), cr_id),1)" as dimension then do a count(cr_id) but that doesn't give the desired results. Using "Round(count(cr_id),1)" as the dimension gives an Invalid dimension error. What would be the best approach?

Thanks in Advance!

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Have you tried

=aggr(count(cr_id), cr_id)


as dimension and


=Count(Distinct cr_id)


as expression?

View solution in original post

1 Reply
swuehl
MVP
MVP

Have you tried

=aggr(count(cr_id), cr_id)


as dimension and


=Count(Distinct cr_id)


as expression?