Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
f1234567
Contributor III
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:

TableCurrent.JPG

 

The calculation formula here is:

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

But how would I get this result?

TableRequired.JPG

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)
1 Solution

Accepted Solutions
edwin
Specialist III
Specialist III

see attached if this is what you were looking for:


View solution in original post

2 Replies
edwin
Specialist III
Specialist III

see attached if this is what you were looking for:


f1234567
Contributor III
Contributor III
Author

Very cool script and solution! Thank you!