topic Year vs Last Year in chart in QlikView

Year vs Last Year in chart

Anonymous — Tue, 01 Oct 2013 09:26:40 GMT

Hi all,

In QlikView I use variables and a master calendar to show revenue of Year vs LastYear (see attached document).

At this moment I only load data of 2013, but I also want to load data of 2014. To do this, I need to set the max Year of my calendar to 2014. Problem is actually that 2014 vs 2013 will be shown per default and I would like to see 2013 vs 2013 per default.

I know I can do this to select 2013 on opening the QV doc, but actually I don't like that.

I hope someone of you can help me out.

Kind regards,

Henco

Re: Year vs Last Year in chart

amars — Tue, 01 Oct 2013 09:38:31 GMT

Check Attached File.

Thanks...

Re: Year vs Last Year in chart

MayilVahanan — Tue, 01 Oct 2013 09:43:00 GMT

Are you expecting this?

Re: Year vs Last Year in chart

Anonymous — Tue, 01 Oct 2013 09:46:34 GMT

Thanks a lot Michael, you really helped me out here.

Regards,

Henco