Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
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?

View solution in original post