# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Contributor

## Show % Difference

Hi guys,

I have the following line chart Is it possible on this same chart to show the % increase/decrease from week to week? For example difference between Week 1 and Week 2 or difference between Week 3 and Week 2?

Not sure if this is possible or not, so thought i would ask the experts! Thanks
J

Labels (2)

• ### Qlik Sense

1 Solution

Accepted Solutions
Valued Contributor

## Re: Show % Difference

Hi

Is this something you had in mind: Staves is the sum of the parcels, line is the percentage (secundary).

Measure used to calculate the percentage is:

```=(
Sum(Parcels)
-
Above(Sum(Parcels),1,1)
)
/
Above(Sum(Parcels),1,1)```

This will result in a percentage that compares one week to the one before.
For example: In week 2, Sum(Parcels) had a positive rise of 83.31% compared to last week.

7 Replies
Esteemed Contributor

## Re: Show % Difference

Hi,

create another line on which you can try to use above() function
Contributor

## Re: Show % Difference

Hi Youssef,

Thank you for the quick reply.  I have never used the above function, so I will look into that

Thanks

Contributor

## Re: Show % Difference

Hi Youssef,

I cannot figure this one out.  I am using a simple sum(parcels) for the line at the moment and the dimension is a week number.

Can you offer any advice as to how to show a percentage difference between the week numbers?

Thanks
J

Valued Contributor

## Re: Show % Difference

Hi

Is this something you had in mind: Staves is the sum of the parcels, line is the percentage (secundary).

Measure used to calculate the percentage is:

```=(
Sum(Parcels)
-
Above(Sum(Parcels),1,1)
)
/
Above(Sum(Parcels),1,1)```

This will result in a percentage that compares one week to the one before.
For example: In week 2, Sum(Parcels) had a positive rise of 83.31% compared to last week. MVP

## Re: Show % Difference

What expression are you using in your line chart right now? Try this
Expression - Above(Expression)
Esteemed Contributor

## Re: Show % Difference

@jamelmessaoud

Sunny's suggestion is what you need

Contributor

## Re: Show % Difference

Thanks for all your help guys. I did sum(Parcels) / Above(Sum(Parcels))

Easy when you know how! Thanks everyone