How to calculate shares in a line chart

[#1]

Hi,

I've attached a .qvw which - I hope - describes my problem in detail.

In short - I'm trying to calculate market shares to be shown in a line chart using built-in functions in Qlikview. My problem is that I dont know how to build an expression that calculate the share for diffrent time periods.

Every hint is greatly appreciated!

[#2 · Accepted solution]

Hi,

Have a look at the straight table that I added as well as the MONTH field that I added in the script.

I had to add the MONTH field, because I use it in the aggr() function.

Regards,

[#3]

It works like a charm!

Thanks a lot, wernbrenk!