group by clause

[#1]

hi,

iwant to execute this request in qlik:

select count(*), field group by field

[agomes1971]

Hi,

you have to be more specific.

Sql Server:

Example:

T:

load *;

SQL

select field, count(*) from yourtable

group by field;

Hope it helps

André Gomes

[#3]

Hi,

Table1:

select * from [table name];

what is your requirement you can achive this easily.

Tab2:

Load Count(*),

         Field

resident Table1 group by field;

[#4]

i want to execut it in a list of selection

[#5 · Accepted solution]

Hi,

in listbox check the show frequency.then it will show the count.

or else

in list box create a expression write the logic

aggr(count(field),field1)