Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

johnirwin
New Contributor

I want to see % in rows for each column in a pivot table.

Ex. rows with % ethnicity with columns of years. I want % for each year of each compared to total for the year/semester. I want to see multiple years. As example below shows I'm getting % of total for all selected years/semesters. I want each % column to sum to 100%.

My expression is

sum(REC_COUNTER_DT) / sum(total REC_COUNTER_DT)

How can I fix this? I know I can select just one semesters and it works, but I want to see multiple semesters.

John

1 Solution

Accepted Solutions
sergio0592
Valued Contributor II

Re: I want to see % in rows for each column in a pivot table.

Hi,

Try with :

sum(REC_COUNTER_DT) / sum(TOTAL <Year> REC_COUNTER_DT)

View solution in original post

2 Replies
sergio0592
Valued Contributor II

Re: I want to see % in rows for each column in a pivot table.

Hi,

Try with :

sum(REC_COUNTER_DT) / sum(TOTAL <Year> REC_COUNTER_DT)

View solution in original post

johnirwin
New Contributor

Re: I want to see % in rows for each column in a pivot table.

Thanks, that worked perfectly!

John