Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lmonincx
Creator II
Creator II

aggr on dimension for 100% per dimension

Hi,

I have data which i want to set to a 100% over the dimension month, I would like to display teh % per prod based on a complete month

example: jan: prod a is 60, prod B is 40 so 60% over 40 % stacked in a column for Jan

for feb prod a is 80, prod b is 20, i would like to see for column Feb 80% over 20 %

using relative it's calculating the percentage over all giving wrong results.

any suggestions how to get the above % in a stacked format so every month is set to 100% , see example.

Many thanks! Linda

1 Solution

Accepted Solutions
Not applicable

maybe you didnt' uncheck the "relative" calculation ?

View solution in original post

4 Replies
Not applicable

Hi Linda

I know 2 solutions

1) use as expression
=sum(qty)/sum(TOTAL <month> qty)

2) use noofrows
=sum(qty)/rangesum(top(sum(qty),1,noofrows()))

regards

JJ

lmonincx
Creator II
Creator II
Author

Hi Jj,

thx, but none of the above gives me a 100% per column on month, i would like each month to roll up to 100% and within this 100% the % of products within that month.

Regards,

Linda

Not applicable

maybe you didnt' uncheck the "relative" calculation ?

lmonincx
Creator II
Creator II
Author

Hi Jj,

You are completly right, it works without the relative, seems time to call it a day i guess Big Smile

regards,

Linda