topic Problem with partial sum in pivot table in QlikView

Problem with partial sum in pivot table

Mon, 24 Aug 2015 03:03:11 GMT

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.

Re: Problem with partial sum in pivot table

sunny_talwar — Mon, 24 Aug 2015 03:17:17 GMT

Try this may be:

=Avg(Aggr(YourExpression, YourChartDimensions))

Re: Problem with partial sum in pivot table

Mon, 24 Aug 2015 03:26:24 GMT

This is for additional information,

Percen Filter

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

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

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

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