topic Before function in line chart in QlikView

Before function in line chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I am trying to create expression using 2 dimensions in line chart.

For Example my 2 dimenions are MonthYear ,code

I want current month sales for the below data,consider A,B,C as number of sales and table below is the result table after calculating the sales of (current month)/(Previous month and Previous code). I achieved this in pivot table expression

sum(Sales)/above(before(sum(Sales))) but I need this in Line chart.

Please help me with this.

Thanks in advance.

Re: Before function in line chart

sunny_talwar — Tue, 31 Jul 2018 11:27:03 GMT

Try this in your chart

Sum(Sales)/Aggr(Above(Aggr(Above(Sum(Sales)), MonthYear, code), code, MonthYear)

Re: Before function in line chart

sunny_talwar — Tue, 31 Jul 2018 11:46:50 GMT

See an example here

Need Help to create roll rate line chart from above and before function