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

    Custom Cross table


      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 }


      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.