Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kunkumnaveen
Specialist
Specialist

how to show YOY in percentage

Hello , i have to show YOY change in percentage

sample data  i got is

Group   Year           value

AD          2014          17713

AD          2015         15012

AD          2016          13875

MF          2014          82742

AD          2015         81375

AD          2016          95777

currently what  i am showing in a line chart

Dimension:1)Year

                  2)Group

Expression:sum(value)

line.png

what i want to show is  YOY of each year

i mean

on top line chart

81375-82742 in percentage

95777-81375 in percentage

on bottom

15012-17713 in percentage

13875-15012 in percentage

So how to show those diff plz

thanks

naveen

1 Reply
MK_QSL
MVP
MVP

Haven't tested but may be something like this

Aggr(IF(RowNo()=1,0,(SUM(value)/Above(SUM(value)))-1),Group,Year)

Untick Suppress Zero Values from Presentation tab.