topic YoY calcuation as per multiple calculations? in QlikView

YoY calcuation as per multiple calculations?

sunilchakala_ql — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

i am trying to calculate YoY as per multple quarters.

i am able to get the result YoY when i am selecting one quarter, but i would like to get the result when user select 2017Q4,2018Q2, then YoY resut needs to automatically calculate (2017Q4,2018Q2/2016Q4,2017Q1)-1.

let me know if any one has tried this.

Thanks

Sunil

Re: YoY calcuation as per multiple calculations?

Anil_Babu_Samineni — Mon, 18 Jun 2018 05:48:33 GMT

What is your YOY formula?

Re: YoY calcuation as per multiple calculations?

sunilchakala_ql — Mon, 18 Jun 2018 05:57:38 GMT

I am trying to calculate as (selected quarter/ last year same quarter)-1, selected quarter and last year same quarter created by vaiable which will give values.this is working when selecting one quarter but i need to get the YoY when user selects multiple quarters.

Re: YoY calcuation as per multiple calculations?

Anonymous — Tue, 19 Jun 2018 05:51:36 GMT

Hi,

Perhaps this could help: Year over year comparison