Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

calculating differences in script by date

Hi!

I am trying to create a trend line and on top of the trend line, I would prefer to have number of differences compared to the previous date.

I have used the same expression for both the bar and value on the point.

two exact same expression but one with bar and one with no visible chart but just value on the point.

so instead of the exact calculation of the number I would like to have today's number - yesterday's number.

I am currently using Date as dimension.

so I want the number of the bar to be like

+30   -20    +34  -12  +34 something like this.

Thank you!

1 Solution

Accepted Solutions
maxgro
MVP
MVP

maybe with the above function

Missing Manual - Above() and Below()

In chart, it could be something as sum(Sales) - above(sum(Sales))

View solution in original post

3 Replies
maxgro
MVP
MVP

maybe with the above function

Missing Manual - Above() and Below()

In chart, it could be something as sum(Sales) - above(sum(Sales))

Not applicable
Author

this is exactly what I needed!  thanks!!

Can I ask you one follow up question?

this is what it looks like now.

is there any way I can put a + sign in front of the positive numbers?

MarcoWedel

Hi,

maybe by changing the format pattern accordingly:

QlikCommunity_Thread_245038_Pic1.JPG

QlikCommunity_Thread_245038_Pic2.JPG

hope this helps

regards

Marco