topic Re: Aggregation (String) in QlikView

Aggregation (String)

riceball — Tue, 11 Jun 2013 04:23:57 GMT

Hi,

I've encountered some aggregation issue for my expression line in pivot table. Would appreciate some help from you guys

I would like my result to look like this (please see highlighted cells).This column will reflect my product name based on the category='Main' group by Country and Brand

Thank you very much!

Re: Aggregation (String)

Gysbert_Wassenaar — Tue, 11 Jun 2013 08:16:34 GMT

Try: if(Category='Main',Product, aggr(NODISTINCT concat({<Category={'Main'}>}DISTINCT Product, ' & '),Country,Brand))

See attached example.

Re: Aggregation (String)

riceball — Tue, 11 Jun 2013 09:14:44 GMT

It works wonders! Thank you so much for your help!!!

Re: Aggregation (String)

riceball — Wed, 19 Jun 2013 03:10:51 GMT

Hi,

I wonder if there is any way I can load the expression into the script? I would like to have a listbox whereby my user can select the product name and the desired result (e.g: If Product A1 was selected, the listbox will show A4&A9 as possible selection)

I tried using resident load group by function but it doesn't seem to work.

Thanks!