Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
MVP
MVP

Re: Frequency distribution chart

Have you tried

=aggr(count(cr_id), cr_id)


as dimension and


=Count(Distinct cr_id)


as expression?

1 Reply
MVP
MVP

Re: Frequency distribution chart

Have you tried

=aggr(count(cr_id), cr_id)


as dimension and


=Count(Distinct cr_id)


as expression?

Community Browser