topic Re: group by clause in QlikView

group by clause

Tue, 11 Nov 2014 15:51:40 GMT

hi,

iwant to execute this request in qlik:

select count(*), field group by field

agomes1971 — Tue, 11 Nov 2014 15:56:01 GMT

Hi,

you have to be more specific.

Sql Server:

Example:

load *;

SQL

select field, count(*) from yourtable

group by field;

Hope it helps

André Gomes

Tue, 11 Nov 2014 15:58:18 GMT

Hi,

Table1:

select * from [table name];

what is your requirement you can achive this easily.

Tab2:

Load Count(*),

Field

resident Table1 group by field;

Tue, 11 Nov 2014 16:02:10 GMT

i want to execut it in a list of selection

Tue, 11 Nov 2014 16:13:28 GMT

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)