topic Re: sum of % in QlikView

sum of %

saumyashah90 — Wed, 13 Apr 2016 09:01:31 GMT

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 — Wed, 13 Apr 2016 09:09:13 GMT

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 — Wed, 13 Apr 2016 09:11:42 GMT

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

saumyashah90 — Wed, 13 Apr 2016 09:23:06 GMT

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 — Wed, 13 Apr 2016 09:25:28 GMT

based on certain dimension say

->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 — Wed, 13 Apr 2016 09:27:46 GMT

Also 0/0 will give you null

sunny_talwar — Wed, 13 Apr 2016 10:02:58 GMT

Can you share a sample qvw of what you have?