Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
how to create group by clause in set analysis.
Thanks and regards,
Shiv
Hello,
Use aggr() function.
Thanks,
ASINGH
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
based on data show top 2 product for every year in chart...
Thanks
Shiv
You can check here: http://community.qlik.com/thread/89055