Problem set analysis

Anonymous — Wed, 25 Jul 2012 09:03:23 GMT

Hi everybody,

I cannot solve a set analysis. I have a pivot table, 3 dimensions: c_magazzino, c_marchio, c_famiglia. 2 expression: sum(amount). The second one is the one that i'm not able to fix.

I need to have the percentage distribution of quantity for each warehouse and for each brand.

Assuming I only have the brand (c_marchio) 7 and the warehouse (c_magazzino) BG01, I created this Set Analysis:

((Sum({<C_MARCHIO={'7'},C_MAGAZZINO={'BG01'}>}VEN_QTA_MOV))/(Sum({<C_MARCHIO={'7'},C_MAGAZZINO={'BG01'}>} TOTAL VEN_QTA_MOV)))

it works, but i cannot generalize the formula.

I would like to have 100% in each total in the cross between d_magazzino (warehouse) and brand (c_marchio).

How can i accomplish this?

Thank you

Re: Problem set analysis

Anonymous — Fri, 10 Aug 2012 13:03:17 GMT

I solved in this way

sum(ven_qta_mov)/sum(total <c_marchio,c_magazzino> ven_qta_mov)

bye

topic Problem set analysis in QlikView

Problem set analysis

Re: Problem set analysis