Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
KimFerguson
Contributor II
Contributor II

How to get percentage Difference in qliksense

I need one help.

I calculate a Difference Between Current Year Sale and Last Year like. www.kohlsfeedback.com Survey

       num(Sum({$<[HSUBSEGM.descr]={"Clinker and Cement"},
    [CALYEAR]={">=$(vCurrentYear)"}>}[_volume_SO]),'##.0')-  num(Sum({$<[HSUBSEGM.descr]
={"Clinker and Cement"},[CALYEAR]={">
=$(vPreviousYear)<=$(vPreviousYear)"}>}[_volume_SO]),
'##.0')

so I m getting and answer Suppose.

This Year sale is 100 $ and Last Year sale was 50 $. so total growth 50 $.

But I want to show growth in %. In this case my Revenue growth is 50 % because it got double from last year..

Labels (1)
1 Reply
sidhiq91
Specialist II
Specialist II

@KimFerguson  i guess your revenue growth is 100 perecent since it has doubled from 50 to 100.

So in general we calculate YOY change as

((Sum of current year- Sum of previous year)/ (sum of previous year ))*100