Custom Cross table

Thu, 11 Aug 2011 11:04:35 GMT

Hello,

I have the following cross table in Qlikview :

The expression is : sum(Active_G)

I need to have the cross table like this :

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

Thu, 11 Aug 2011 11:57:41 GMT

Sorry for bad quality of the pictures; you can clic on it to get it in a better quality.

topic Custom Cross table in QlikView