topic Re: Sliding change in QlikView

Sliding change

Wed, 25 Nov 2020 16:16:04 GMT

Hello There,

In the table below I'm looking for an expression that is able to determine the sliding change per every 5 minutes. In other words, I'm looking for an expression that would show the difference between the value of 'Measure' at 5 mins and 1 min (i.e. difference between 594.00 and 433.36), at 10 mins and 5 mins (i.e. difference between 589.49 and 594.00), at 15 mins and 10 mins (i.e. difference between 579.36 and 589.49) etc, etc. Any ideas please?

Re: Sliding change

marcus_sommer — Fri, 19 Aug 2016 05:45:55 GMT

You could use Peek() or Previous() ? for this. If your time-line is really continuous you could use something like this:

...

if(mod(minute(Time), 5) = 0, Measure - peek('Measure', -4), 'else value') as MeasuresDiff

...

If not it will be need more efforts to determine the if-checks to find the right previous record.

- Marcus

Re: Sliding change

Fri, 19 Aug 2016 08:09:59 GMT

Thanks Marcus,

It appears the functions Peek() or Previous() does not exist on my list of functions. Is this to do with version?

Re: Sliding change

marcus_sommer — Fri, 19 Aug 2016 08:25:48 GMT

You mean list of functions - they aren't fields. And they are included in each version. The versions have no differences within the functionalities only in the right to share an application or not.

- Marcus

Re: Sliding change

Fri, 19 Aug 2016 08:35:25 GMT

Yes correct, functions!

So in this case do you have any idea why can I not see these two functions? Very strange!

Re: Sliding change

marcus_sommer — Fri, 19 Aug 2016 08:55:23 GMT

Peek and previous are script-functions and aren't available within the gui. Have you looked into the document which I mentioned above?

- Marcus

Re: Sliding change

spividori — Fri, 19 Aug 2016 10:28:48 GMT

Hi.

See the atached example. It is referred to Marcus.

Regards.