topic Re: Current year versus last year in QlikView

Current year versus last year

bikasehel — Tue, 01 Feb 2022 10:07:59 GMT

Hi there,

I am mainly a Tableau guy, but I have an issue with Qlikview where I have to offset the current year versus last year. I'm sure it's an easy thing, but I can't find out what the solution might be. Can anyone help?

Re: Current year versus last year

Lucas_Gatling — Tue, 01 Feb 2022 15:33:28 GMT

It sounds like using alternate states would be the best way to go here. Here are some links for what alternate states are and some examples of it being used with using current year vs. last year.

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Alternate%20States.htm

https://community.qlik.com/t5/QlikView-App-Dev/Alternate-States-Current-Year-vs-Prior-Year/m-p/336307

http://www.qlikfix.com/2014/08/12/alternate-states/

Re: Current year versus last year

Lucas_Gatling — Tue, 01 Feb 2022 15:33:42 GMT

It sounds like using alternate states would be the best way to go here. Here are some links for what alternate states are and some examples of it being used with using current year vs. last year.

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Alternate%20States.htm

https://community.qlik.com/t5/QlikView-App-Dev/Alternate-States-Current-Year-vs-Prior-Year/m-p/336307

http://www.qlikfix.com/2014/08/12/alternate-states/