topic Using TOTAL get percentage rate in a pivot chart in QlikView

Using TOTAL get percentage rate in a pivot chart

Fri, 30 Oct 2009 02:29:46 GMT

This is my first post to the forum and I'm hoping someone else has attempted the same type of thing. I've attached an example file that was created with 8.2.

I'm trying to combine the information in the two first charts to look like that last chart. My problem is that when I use 'Suppress When Value Is Null' in the 3^rd chart I lose the values I need to get the proper total in order to get the correct % rate. The last chart has the correct values to get the right percentage, but I don't want to display the last row.

Thanks for you assistance.

Jonathan

Using TOTAL get percentage rate in a pivot chart

disqr_rm — Sun, 01 Nov 2009 05:55:23 GMT

See enclosed. Is this what you are looking for?

Using TOTAL get percentage rate in a pivot chart

Sun, 01 Nov 2009 08:43:28 GMT

OAD * INLINE [
CustNo, CustAge, AgeSinceAdd, TransID, Amount
1, 1, 1, 1, 10
2, 1, 5, ,
3, 1, 1, 2, 20
4, 1, 5, ,
5, 1, 1, 3, 30
6, 2, 2, 4, 40
6, 2, 2, 5, 50
6, 2, 2, 6, 60
7, 2, 5, ,
8, 2, 1, 8, 80
8, 2, 1, 9, 90
8, 2, 1, 10, 100
8, 2, 1, 7, 70
9, 2, 5, ,
];

INNER JOIN

LOAD * INLINE [
AgeSinceAdd, AgeSinceAddDesc
1, 1 Week
2, 1 Month
3, 3 Months
4, 6 Months ];

Using TOTAL get percentage rate in a pivot chart

Fri, 06 Nov 2009 04:28:09 GMT

Rakesh,

Worked Perfectly! Thanks!

Using TOTAL get percentage rate in a pivot chart

Anonymous — Fri, 01 Jul 2011 14:14:41 GMT

Very nice, saved me some troubles. However, add a total and it looks odd (blanks)?

/Nicolai