While using the chart object in the qlikview, I was able to produce the desired dimensions and expressions even. But Going a step further I wanted to see the accumulated value of the expression for a dimension. Lets say if we are having a data showing the sales on different dates in different months.
Now what I want is the first dimension will be months and the other one will be Date and the expression will be "sum(sales)" but what else I need to know is that what is the accumulated sales for each month in the same table and also the share of sales done in each day in a month i.e. the base is each month. I want to evaluate each day with respect to that particular month.
