Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

group by clause

hi,

iwant to execute this request in qlik:

select count(*), field group by field

1 Solution

Accepted Solutions
Not applicable

Re: group by clause

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)

4 Replies
agomes1971
Valued Contributor

Re: group by clause

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

Not applicable

Re: group by clause

Hi,

Table1:

select * from [table name];

what is your requirement you can achive this easily.

Tab2:

Load Count(*),

         Field

resident Table1 group by field;

Not applicable

Re: group by clause

i want to execut it in a list of selection

Not applicable

Re: group by clause

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)

Community Browser