Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
About the best point in the right direction I have, hopefully helps a little.
Regards,
Brett