Frequency Count

[#1]

Hi All,

I have a survey table with have Caller Name. I want to calculate How many names appear 1 time , How many appear 2 times How many appear 3 times, how many appear 4 times and so on. I need number and % both as measure and No. of times i.e 1, 2, 3, .... as dimension. Please help. Thanks

[lfetensini]

Try that:

Script Source Example:

Answers:

LOAD * INLINE [

    Answers

    One

    One

    One

    Two

    Two

    Three

    Three

    Three

    Three

    Four

    Four

    Five

    Five

    Five

    Five

    Six

    Six

    Six

    Six

];

Chart:

Dimension: Answer

Expression 1: count(Answers)

Expression 2: count(Answers)   >> SET RELATIVE OPTION

[rwunderlich]

With Dimension of "Caller Name", an expression of "Count([Caller Name])" will provide the count for each caller.

To create the dimension as count, use the calculated dimension of:

=Aggr(count([Caller Name]), [Caller Name])

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[#4]

Thanks Rob. Its great.