1 Reply Latest reply: Nov 30, 2015 5:41 PM by Stefan Wühl RSS

    Frequency distribution chart

    Aravind Sasidharan

      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!