1 Reply Latest reply: Aug 11, 2011 7:57 AM by Yacine Bousnina RSS

    Custom Cross table

      Hello,

      I have the following cross table in Qlikview :

      cross table qv.png

      The expression is : sum(Active_G)

       

      I need to have the cross table like this :

      cross table.png

      It's calculated by the way:

      for each row; cell=sum(Active_G) / { first cell of the row }

      example:

      C2=255969/255969             D2=233454/255969        E2=216060/255969 ...

      C3=155121/155121             D3=138034/155121        E3=125666/155121 ...

       

      Could you help me please to get this cross table.

       

      PS: I attached the qvw file with data, it can helps you.

       

      Regards,

      Yacine