Frequency distribution chart

[#1]

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:

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!

[swuehl · Accepted solution]

Have you tried

=aggr(count(cr_id), cr_id)

as dimension and

=Count(Distinct cr_id)

as expression?