Discussion Board for collaboration related to QlikView App Development.
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
maybe you didnt' uncheck the "relative" calculation ?
View solution in original post
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()))
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.
You are completly right, it works without the relative, seems time to call it a day i guess