topic Re: Pivottable / crosstab - How can I use partial sums to calculate fractials in the table? in QlikView

Pivottable / crosstab - How can I use partial sums to calculate fractials in the table?

Sun, 28 Dec 2014 14:25:19 GMT

Hi,

I'm trying to calculate percentage from the partial sum in a pivot table, like the example shown below, but I am not able to do it in Qlikview:

Sum of Counter	Column Labels
Row Labels	Fair	Good	Poor	Grand Total
Fair	66,7 %	22,2 %	11,1 %	100,0 %
	6	2	1	9
Good	23,5 %	41,2 %	35,3 %	100,0 %
	4	7	6	17
Poor		100,0 %		100,0 %
		1		1
Grand Total	10	10	7	27

How can I use the partial sum for dim 1 to calulate the distribution for dim 2 in percentages in stead of absoulte numbers? Does anybody have any ideas?

In this post I have enclosed an app and the data file for the app. I have borrowed the example from this post:

http://community.qlik.com/thread/133200

Re: Pivottable / crosstab - How can I use partial sums to calculate fractials in the table?

ecolomer — Sun, 28 Dec 2014 14:30:30 GMT

id that you need?

Re: Pivottable / crosstab - How can I use partial sums to calculate fractials in the table?

Sun, 28 Dec 2014 14:35:23 GMT

Hi, thanks for input but no;

this is a fraction of total sales, not sub totals for dim 1. This is the examples I have found and further developed to the app enclosed in my post

Re: Pivottable / crosstab - How can I use partial sums to calculate fractials in the table?

ecolomer — Sun, 28 Dec 2014 14:41:39 GMT

Now?

Re: Pivottable / crosstab - How can I use partial sums to calculate fractials in the table?

Sun, 28 Dec 2014 14:48:44 GMT

Yes, the 3rd table there is exctly what I'm looking for!

Re: Pivottable / crosstab - How can I use partial sums to calculate fractials in the table?

ecolomer — Sun, 28 Dec 2014 14:50:45 GMT

the qv file attached

Re: Pivottable / crosstab - How can I use partial sums to calculate fractials in the table?

Sun, 28 Dec 2014 14:51:50 GMT

hope this attached file help you to achieve your requirement..

Re: Pivottable / crosstab - How can I use partial sums to calculate fractials in the table?

ecolomer — Sun, 28 Dec 2014 17:14:35 GMT

if the problem is resolved, please indicate the answer that was correct and so the question will be closed

Re: Pivottable / crosstab - How can I use partial sums to calculate fractials in the table?

Mon, 29 Dec 2014 10:05:20 GMT

Thanks a lot! Exactly the simple built-in function I was looking for that solves the issue!