Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

paolojolly
New Contributor III

problem with grouped values

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

C_CLIENTED_CANALE_ANAGRC_LINEA_FATW_TOT_KG
C0001299GD132-144
C0001299GD005-140
C0001299GD138-120
C0001299GD005-100
C0002266GD132352
C0002266GD016360
C0002266GD138360
C0002408GD & DO022120
C0002408GD & DO132184
C0002408GD & DO132192
C0002408GD & DO016

240

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

Tags (3)
4 Replies
whiteline
Honored Contributor II

Re: problem with grouped values

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)

jsaradhi
Valued Contributor

Re: problem with grouped values

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
New Contributor III

Re: problem with grouped values

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

jsaradhi
Valued Contributor

Re: problem with grouped values

yes, that looks good to me.

Community Browser