topic how does show increase or decrease variation in qlikview in QlikView

how does show increase or decrease variation in qlikview

kunkumnaveen — Tue, 18 Apr 2017 09:26:08 GMT

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 — Tue, 18 Apr 2017 09:34:01 GMT

i tried this expression

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

but unfortunately it is showing a line at zero

kunkumnaveen — Tue, 18 Apr 2017 09:38:59 GMT

Any suggestions please

kunkumnaveen — Tue, 18 Apr 2017 10:00:36 GMT

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