Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
jamelmessaoud
Contributor

Show % Difference

Hi guys,

I have the following line chart

Line.PNG

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! :smileyhappy:

Thanks
J

Labels (2)
1 Solution

Accepted Solutions
timpoismans
Valued Contributor

Re: Show % Difference

Hi

 

Is this something you had in mind:

Diff%.PNG

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
YoussefBelloum
Esteemed Contributor

Re: Show % Difference

Hi,

create another line on which you can try to use above() function
jamelmessaoud
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

jamelmessaoud
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

timpoismans
Valued Contributor

Re: Show % Difference

Hi

 

Is this something you had in mind:

Diff%.PNG

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.

Re: Show % Difference

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

Re: Show % Difference

@jamelmessaoud

Sunny's suggestion is what you need

jamelmessaoud
Contributor

Re: Show % Difference

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

Easy when you know how! :smileyvery-happy:

Thanks everyone