Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with partial sum in pivot table

Hi,

I have a question,

I have a data that shown in pivot table with brand dimension, i also has two percentage filter (input box) that user can input with percentage range  (from - to).

When i input the range between 80 and 100, each data per brand show correctly, but the total isn't shown, i thought it's because the total has percentage below 80%. When i calculate the total from each data per brand, the total is about x=100 and y =90, and its correct that it must be above 80 %, but why the partial sum is below 80 % ?

sorry if my statement is not too clear, thanks

Really appreciate your help.

2 Replies
sunny_talwar

Try this may be:

=Avg(Aggr(YourExpression, YourChartDimensions))

Not applicable
Author

This is for additional information,

Percen Filter

percentage.png

When i input percentage between 50 and 100, the data show like this :

50-100percen.png

The total is 455,342, and percentage is 75 %

When i input percentage between 70 and 100 the data show like this :

70-100.png

The first column not show, because it is 63% (below 70), but the tota lstill 455, 342, and, 75%. I want to make it flexible, when i input 70 and 100 the total must be 415, 317, 76%.

Do you have any idea ?

Thanks