Current Year VS Last Year Growth but months same as current year

[usmanghani96]

Hi All,

I have a table chart have two columns Party and Growth.

I want to compare growth CY vs LY but months will be the same as CY like. CY have 11 months data so it will compare to LY same months (11 months) as CY not hole LY (12 Months).

Example :

Current Year Have Following months.

Jul-2019, Aug-2019, Sep-2019, Oct-2019, Nov-2019, Dec-2019, Jan-2020, Feb-2020, Mar-2020, Apr-2020, May-2020.

so Last Year will be compare to exact months  (we have 12 months data but want to compare same months as CY).

Jul-2018, Aug-2018, Sep-2018, Oct-2018, Nov-2018, Dec-2018, Jan-2019, Feb-2019, Mar-2019, Apr-2019, May-2019

Regards

UG

[Brett_Bleess]

Have a look at the following links, hopefully one of them will get you on the right track:

https://community.qlik.com/t5/Qlik-Design-Blog/Year-over-Year-Comparisons/ba-p/1462927

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511

You can also search here: https://community.qlik.com/t5/QlikView-Documents/tkb-p/qlikview-documents

There are quite a few posts there too that may be helpful.  

Regards,
Brett