how to find total occurence of identical value form the list of data available

[#1]

how to count the total occurance of same value from list of values.

here is example of data.

thank you in advance

[#2]

in your list box tick the checkbox show frequency:

eg:

suppose you want to see total occurence of each customer, take customer name in list box and tick show frequency.

[#3]

hi,

as i am new to qlik . i tried but result was different than i need. i like to show that there is five 1's, twelve 2's, six 3's and so on...

so that i can later on use this value to make frequency distribution chart for those value.

thanks

[#4]

if you want to use frequecy of id's later then you have to define this in your script as:

a:

load * from tablename;

b:

load *, if(id='1', id) as x,

if(id='2', id) as x1,

if(id='3', id) as x2

resident a;

drop table a;

c:

load *,

count(x) as y,

count(x) as y1,

count(x) as y2

resident b;

drop table b;

[#5]

Hi,bandanakarki .

Use 'group by'  in your script.

MAIN_Table:

LOAD *

FROM your xls file

next_table:

LOAD

     A,

     COUNT(A) as frequency

RESIDENT  MAIN_Table group by A;

[#6]

Thank you for suggestions,

problem solved by using =class(value, range) in dimension

and count(value) in expression

i hope output is correct now and represents frequency distribution of the value.

thank you all