Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
iwant to execute this request in qlik:
select count(*), field group by field
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)
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
Hi,
Table1:
select * from [table name];
what is your requirement you can achive this easily.
Tab2:
Load Count(*),
Field
resident Table1 group by field;
i want to execut it in a list of selection
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)