topic Re: Pivot Table with Column Percentages in QlikView

Pivot Table with Column Percentages

wonkymeister — Mon, 03 Jul 2017 10:30:02 GMT

Hi,

I have a pivot table, with YEAR across the top (3 years so 3 columns), with the user being able to select from a list of available dimensions down the side.

I need the % to calculate for each individual column (year), as opposed to a percentage of the total.

Any ideas?

Re: Pivot Table with Column Percentages

jmvilaplanap — Mon, 03 Jul 2017 10:48:19 GMT

As I can see, I think you are doing a percentage about the total, for example in the first cell is the percentage of the Stage 1 in 2015/6 about the total.

I think, you need only use the "function" TOTAL, for example: =sum(valueField)/sum(TOTAL valueField), isn't it?

Regards

Re: Pivot Table with Column Percentages

wonkymeister — Mon, 03 Jul 2017 10:50:38 GMT

nope - tried that with no success

Re: Pivot Table with Column Percentages

jmvilaplanap — Mon, 03 Jul 2017 10:52:03 GMT

Could you give me a dataset for testing?

Re: Pivot Table with Column Percentages

jmvilaplanap — Mon, 03 Jul 2017 10:59:11 GMT

I tested and it works for me, I'll show you

you can see the expressions at the top of the fields.

P.S. I'm sorry but I don't know how to upload a *.qvw file.

Re: Pivot Table with Column Percentages

wonkymeister — Mon, 03 Jul 2017 11:05:32 GMT

sorry - want i want is the percentage of stage for that year only: like this:

Re: Pivot Table with Column Percentages

jmvilaplanap — Mon, 03 Jul 2017 11:15:54 GMT

Then, the expression is: sum(Value)/sum(TOTAL <Year> Value)

Re: Pivot Table with Column Percentages

wonkymeister — Mon, 03 Jul 2017 11:19:47 GMT

Jose sir you are a legend.

thank you

Re: Pivot Table with Column Percentages

jmvilaplanap — Mon, 03 Jul 2017 11:27:38 GMT

You're welcome Phillip

Re: Pivot Table with Column Percentages

wonkymeister — Mon, 03 Jul 2017 14:48:48 GMT

just a thought - can this be done in Set analysis also?

Re: Pivot Table with Column Percentages

jmvilaplanap — Mon, 03 Jul 2017 14:55:33 GMT

I think no, because there is in a pivot table, then automatically the results are "filtered" to fit each cell, is because you need to use "TOTAL"

It will be possible to use it in a text object using filters, but I think is not that are you looking for.