topic Re: Grouping in set analysis in QlikView

Grouping in set analysis

madhuqliklondon — Wed, 25 Nov 2020 16:16:04 GMT

Hi Friends ,

I am trying to get grouping done in expression level. What I got in attached file is I am trying to understand free item offers making customers buy products and calculating their associated products. With the help of stalwar1‌ I got to this point , now I am trying to do is group items by brand in order level it self and I do not want to calculate other products in that order for example in order number 1

(see attached) totals of Sony only leaving other products because I want to calculate bundle offers as the promotion. Mostly same brand products are higher in an order , other brands products are less any way if this gives any ideas. Please select free on filter.

expected results:

item	quantity	totals
lg 3d glasses	1	550
samsung ear phones	1	650
sony ear phones	1	300

Thanks in advance .

Re: Grouping in set analysis

sunny_talwar — Tue, 27 Jun 2017 13:48:49 GMT

May be this

Sum({<product_type={'free'}>}

Aggr(

Sum(TOTAL <[order number], brand> {<[order number] = P({<product_type={'free'}>}[order number]),product_type>}[amount])

,[order number],item.no, brand))

Re: Grouping in set analysis

madhuqliklondon — Tue, 27 Jun 2017 14:27:29 GMT

Thank you Sunny(Super Star).

Re: Grouping in set analysis

madhuqliklondon — Tue, 27 Jun 2017 14:42:11 GMT

Hi Sunny,

Can you explain in simple terms what the expression is doing ?

Re: Grouping in set analysis

madhuqliklondon — Fri, 30 Jun 2017 08:19:10 GMT

stalwar1‌ Sunny,

When you have free time please explain.

Many thanks