topic Re: Get 6 last values average in front end in QlikView

Get 6 last values average in front end

MindaugasBacius — Thu, 11 Feb 2021 12:54:47 GMT

Hello,

In the front end I have a table like this:

The expression: (Sum(Value1) + Sum(Value2))/ Sum(Value3)

The customer wishes to get a table that shows the last 6 values average for each Supplier:

The result depends on the Date selections - like supplier c there is only one value and the result is calculated from only one value. But with d supplier, there are more than 6 values. In this case, only the last 6 values should figure while calculating average.

All the calculations have to be made in front end.

Thank you!

Re: Get 6 last values average in front end

MindaugasBacius — Thu, 11 Feb 2021 12:53:19 GMT

Every advice would earn you some karma points 🙂

Re: Get 6 last values average in front end

marcus_sommer — Fri, 12 Feb 2021 11:39:04 GMT

Maybe something like this:

if(Date >= max(Date, 6), avg(Value))

- Marcus

Re: Get 6 last values average in front end

MindaugasBacius — Fri, 05 Mar 2021 08:24:41 GMT

I now get the idea! Thank you.