In-record AVG

Sergio3 — Thu, 20 Aug 2020 13:57:39 GMT

Hello everybody!

I have some intersting ( for me ) case.

Data:

I need to do in script AVG() for prices if they changed in one month:

How i can do this?

Thank u!

Sergio

Re: In-record AVG

Brett_Bleess — Thu, 03 Sep 2020 14:08:35 GMT

You will need to get the data ordered in the load scrip such that you can use Peek() function to determine when things have changed and do your check to see if next record requires the average etc. If you want to do things in the visualization, then Set Analysis is likely the only option I believe. Here are some links that may be helpful:

https://community.qlik.com/t5/Qlik-Design-Blog/Average-Which-average/ba-p/1466654

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/load-data-from-previously-loaded-table.htm

About the best point in the right direction I have, hopefully helps a little.

Regards,
Brett

topic Re: In-record AVG in QlikView

In-record AVG

Re: In-record AVG