4 Replies Latest reply: Jun 23, 2014 1:33 PM by Saradhi Balla RSS

    problem with grouped values

    Paolo Guidolin

      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