Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to count the total occurance of same value from list of values.
here is example of data.
thank you in advance
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.
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
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;
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;
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