sum of %

[saumyashah90]

Header 1	Header 2	Header 3	Header 4	Header 5
1	4	6	1	25%
2	-	7	-	-
-	-	8	-	-
-	5	9	4	80%
0	0	0	0	-
3	9	30	5	-

Here Row in brown is total(Sum of rows) but header 5 is percentage which is (header2/Header4)*100... it should actually show 55%

When i do Toal from expression it shows null for all.

help?

[swuehl]

Could you please describe a bit more detailed which dimensions / expressions you have used?

If possible, upload a small sample QVW that also shows how your data model looks like.

[Gysbert_Wassenaar]

Try sum(header2)/sum(Header4)*100.

[saumyashah90]

Hi gysbert,

The total is qlikview default total in Expression Tabs.

And also the headers used is dynamic and not static

like  ='ABC '&chr(13)&'('&chr(39)&'m)'

[saumyashah90]

based on certain dimension say

ID

->there are some Id who have transaction and some who doesnt have, we need to show all Id's.

-> Sum of values are all the headers 1,2,3,4

[saumyashah90]

Also 0/0 will give you null

[sunny_talwar]

Can you share a sample qvw of what you have?