Hi I'm new in Qlikview and I need help to create from the excel file attached a pivot table with in expression a value like this
(
sum(
if (W_TOT_KG_CAMP >= 0.01,
(W_PREZZO_NOCOMP * W_TOT_KG) - W_TOT_IMP_RIGA
)
)
/
sum(
(W_PREZZO_NOCOMP * W_TOT_KG)
)
)
/
(
//the value of
sum(
if (W_TOT_KG_CAMP >= 0.01,
(W_PREZZO_NOCOMP * W_TOT_KG) - W_TOT_IMP_RIGA
)
)
/
sum(
(W_PREZZO_NOCOMP * W_TOT_KG)
)
//for the group D_MARCHIO_STAT,D_CANALE_PADRE_STORICO,CD_LINEA_FAT
//making sure that If I select an item from Customer selection box the value of this group
//should be not only the value of the selected Customer but the sum of the value of all Customer
//that have the same D_CANALE_PADRE_STORICO of the selected Customer
)
To get the value of the group is correct to use
max(
Aggr(
sum( TOTAL <D_CANALE_PADRE_STORICO,C_LINEA_FAT> {$<CD_CLIENTE = >}
if (W_TOT_KG_CAMP >= 0.01,
(W_PREZZO_NOCOMP * W_TOT_KG) - W_TOT_IMP_RIGA
)
)
/
sum( TOTAL <D_MARCHIO,D_CANALE_PADRE_STORICO,C_LINEA_FAT> {$<CD_CLIENTE = >}
(W_PREZZO_NOCOMP * W_TOT_KG)
)
, D_MARCHIO, D_CANALE_PADRE_STORICO,C_LINEA_FAT)
)
I attach a sample document
Can someone help me?
thanks
