Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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