Qlikview - Table chart per month %

[maartenmol]

My script is the following:

sum({1< TypeofFact= {'Lawyer'}
[Year] = {$(vThisyear)}
>}_total_value)

This gives the following output:

How can i make the second pivot table?

[Frank_Hartmann]

try this as expression:

sum(aggr(sum(Data)/aggr(NODISTINCT sum(Data),Date),Lawyer,Date))

Replace Data and Date  Field according your environment

[maartenmol]

Dear Frank,

this looks perfectly for the months. Thanks for the info.

Only the total at the end is still incorrect.

It summarises all the months (until July):

Network:      361%

Free choice 339%

Total               700%   (7 months x 10)%)

[Frank_Hartmann]

what happens if you also  activate "showPartialSum" for your Date dimension?

[jfkinspari]

Unless I'm overlooking something, it seems overkill to use AGGR function, as you can just use the TOTAL keyword to specify the scope of the calculation.

[Frank_Hartmann]

have a look at the attached sample.

Both TOTALS should be displayed correct!

hope this helps.

[Brett_Bleess]

Did the example app Frank provided work?  If so, be sure to give him credit by clicking the Accept as Soluiton button on his post.  If not, please provide further information, so we can try to help you get things figured out.  If you are unable to click the button for some reason, you can also just reply that it did work, and we can be sure things get updated accordingly.

Regards,
Brett