Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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

4 Replies
Highlighted
Master II
Master II

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)

Highlighted
Specialist
Specialist

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?

Highlighted
Creator
Creator

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

Highlighted
Specialist
Specialist

yes, that looks good to me.