Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

1 Reply
Not applicable
Author

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