how to create group by clause in set analysis

[#1]

Dear All,

how to create group by clause in set analysis.

Thanks and regards,

Shiv

[#2]

Hello,

Use aggr() function.

Thanks,

ASINGH

[Sokkorn]

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

[#4]

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

Thanks

Shiv

[#5]

You can check here: http://community.qlik.com/thread/89055