topic Re: Qlikview - Table chart per month % in QlikView

Qlikview - Table chart per month %

maartenmol — Tue, 09 Jul 2019 10:13:41 GMT

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?

Re: Qlikview - Table chart per month %

Frank_Hartmann — Tue, 09 Jul 2019 10:31:30 GMT

try this as expression:

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

Replace Data and Date Field according your environment

Re: Qlikview - Table chart per month %

maartenmol — Tue, 09 Jul 2019 10:57:19 GMT

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)%)

Re: Qlikview - Table chart per month %

Frank_Hartmann — Tue, 09 Jul 2019 11:17:15 GMT

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

Re: Qlikview - Table chart per month %

jfkinspari — Tue, 09 Jul 2019 11:45:31 GMT

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.

Re: Qlikview - Table chart per month %

Frank_Hartmann — Tue, 09 Jul 2019 14:29:55 GMT

have a look at the attached sample.

Both TOTALS should be displayed correct!

hope this helps.

Re: Qlikview - Table chart per month %

Brett_Bleess — Wed, 31 Jul 2019 18:19:58 GMT

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