Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

how to create group by clause in set analysis

Dear All,

how to create group by clause in set analysis.

Thanks and regards,

Shiv

4 Replies
Not applicable

Re: how to create group by clause in set analysis

Hello,

Use aggr() function.

Thanks,

ASINGH

Sokkorn
Honored Contributor

Re: how to create group by clause in set analysis

Hi Shiv,

Aggr() function may do this job. Sample Aggr(Only( {$<Product = {'AB*','BB*'}>} Seller),Product)

Anyhow, can you describe your requirement with sample data. So that people in community can understand your issue well.

Regards,

Sokkorn

Not applicable

Re: how to create group by clause in set analysis

based on data show top 2 product for every year in chart...

Thanks

Shiv

Not applicable

Re: how to create group by clause in set analysis

Community Browser