how does show increase or decrease variation in qlikview

[kunkumnaveen]

Hello All,

               i need to show % increase or % decrease Variation  between quarters

let say i got

Year        Quarters       value

2017           q1                   200

2017          q1                  100

2017              q1                300

2017            q2              100

2017           q2                  200

2017              q2               300

.............

.......................................

so on till quarter 4 i  got data

i expression like this

q1 q2-q1 %  q3-q2% q4-q3%

so in line chart i will add

dimension

Quarters

what Expression should i need to write ?

Thanks

[kunkumnaveen]

i tried this expression

sum(value)/before(sum(value))-1

but unfortunately it is showing a line at zero

[kunkumnaveen]

Any suggestions please

[kunkumnaveen · Accepted solution]

i tried using Above function as well,but it not working