Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Valued Contributor

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
MVP
MVP

Re: how to show YOY in percentage

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.