topic Re: Expression to show all values in QlikView

Expression to show all values

yvonne-c — Sat, 16 Nov 2024 02:44:02 GMT

Im trying to complete the table below, can anybody help with the changes to the DLWG 3 batch per rearer expression to make this table populate completely, and so I can show these values in a chart?

DLWG :

Avg({<[DLWG1]-={"0"},[DATE IN] = {"$(=Max([DATE IN]))"}>} aggr(rangeavg(above(Total Avg({<[DATE IN]=,[DLWG1]-={"0"}>}DLWG1),0,3)),[DATE IN]))

DLWG 3 batch:

Avg({<Rearer,[DLWG1]-={"0"},[DATE IN] = {"$(=Max([DATE IN]))"}>}Aggr(rangeavg(above(Total Avg({<Rearer,[DATE IN]=,[DLWG1]-={"0"}>}DLWG1),0,3)),[DATE IN],Rearer))

This should be the average of DLWG1 for the 3 most recent DATE IN per REARER

Some sample data attached

Re: Expression to show all values

Frank_Hartmann — Thu, 15 Aug 2019 10:46:07 GMT

can u share the qvw or at least some rawdata?

Re: Expression to show all values

yvonne-c — Fri, 16 Aug 2019 08:09:08 GMT

Example of data attached, this is what I am trying to achieve

Thanks

Re: Expression to show all values

Frank_Hartmann — Fri, 16 Aug 2019 12:52:39 GMT

see attached file

hope this helps

Re: Expression to show all values

yvonne-c — Fri, 16 Aug 2019 14:40:52 GMT

Thankyou !

Yes that works, the only problem is when there are less than 3 batches.

So is there a way I can change the /3 part on the end to divide by a count of the DATE IN up to 3 ( so if there are only two batches it will divide by two)

Re: Expression to show all values

Frank_Hartmann — Fri, 16 Aug 2019 16:27:55 GMT

see attached qvw