Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Before function in line chart


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.

2 Replies

Try this in your chart

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