I have set on the relative option so that I get max 100%.
I found these expressions when I searched community.qlik.com. But I didn’t found what I was looking for.
When I select one day my bar has 100%
When I select more than one day the 100% is spread over the days, the sum is still 100%. What I want is that no matter how many days I select, every bar should be 100%.
I think it has to do with Total LineAmount which is calculated for all the selected days and then divided per Interval over the selected days. I think that the Total LineAmount should also be calculated per day, that is why I hoped Sum(LineAmount) / Sum(Total <PostingDate> LineAmount) was the solution, but it was not.
So now the question is: how do I do that, how should I change the expression to get the wanted bars with every day 100%?
Hope someone has a suggestion or the solution for me