# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for
Did you mean:
Contributor III

## Calculate Shares for a dimension (e.g. Supplier) AND a time period

Hello experts,
I have a question which looked easy in the beginning. However, I didn't get it right.

I have following Dimensions :

Product, Distr, Producer, Period
(Period is a Group out of a calendar and can be changed from YYYY_MM to Quarter, to year)

The Pivot Table:

The calculation formula here is:

Sum({<Distr= >} [Daten])

But how would I get this result?

As soon as I add "Total" to the formula, it would calculate the full period selected as total and not total month by month (or quarter to quarter or year to year if the group "Period" is clicked).
I am sure there is a set analysis formula to be used but I couldn't find any to give me above solution.

Many thanks for any hint!
Best
Frank

Labels (3)

• ### Shares by Dimension and Period

1 Solution

Accepted Solutions
Master

see attached if this is what you were looking for:

2 Replies
Master

see attached if this is what you were looking for:

Contributor III
Author

Very cool script and solution! Thank you!