topic Re: problem with grouped values in QlikView

problem with grouped values

paolojolly — Mon, 23 Jun 2014 16:40:48 GMT

Hi I'm new in Qlikview and I need help to create a pivot table from the follow excel table

in the pivot table I have to insert as dimension fields C_CLIENTE and D_CANALE_ANAGR and as expressions the value of

sum(W_TOT_KG) for each C_CLIENTE / sum(W_TOT_KG) group for D_CANALE_ANAGR.

For example for C_CLIENTE C0001299 i need to have -504 / 568 = -0,88732

If I select from a list box a single value C_CLIENTE I expect that the value of sum(W_TOT_KG) group for D_CANALE_ANAGR does not change

I attach a sample document

Can someone help me?

thanks

whiteline — Mon, 23 Jun 2014 17:15:04 GMT

Hi.

And what is the problem ? You have already done that.

You can combine and use one expression:

sum(W_TOT_KG)/sum(TOTAL <D_CANALE_ANAGR> {$<C_CLIENTE = >}W_TOT_KG)

Anonymous — Mon, 23 Jun 2014 17:15:15 GMT

i just checked your formulae for the example data in your post and the results are on par with what you expect. what am i missing?

paolojolly — Mon, 23 Jun 2014 17:23:56 GMT

thanks for the reply, I just wanted to know if I have found the best solution

Anonymous — Mon, 23 Jun 2014 17:33:46 GMT

yes, that looks good to me.