topic Re: calculating differences in script by date in QlikView

calculating differences in script by date

Wed, 25 Nov 2020 16:16:04 GMT

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!

maxgro — Tue, 03 Jan 2017 18:09:05 GMT

maybe with the above function

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

Tue, 03 Jan 2017 18:33:11 GMT

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 — Wed, 04 Jan 2017 00:10:21 GMT

Hi,

maybe by changing the format pattern accordingly:

hope this helps

regards

Marco