Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

How to handle date as dimension in charts

Hi I do have a problem.

I do have a dimension in my charts which is year.

I would like to be able to have reference period which can be on 2 years.

I would like for example to compare datas from 1/12/2014 to 15/01/2015 with datas from

1/12/2013 to 15/01/2014 and 01/12/2012 to 15/01/2013.

Instead of being splitted years datas will be on charts splitted by periods

If you need further details please tell me.

thanks

1 Reply
stigchel
Honored Contributor

Re: How to handle date as dimension in charts

Hi Arnaud,

There are many, many topics regarding this already on the forum. Please try to search the community (type your query in the upper right search area) for answers before asking your question.

Examples:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/10/relative-calendar-fields#comment-8173

Simply create YTD, moving totals and comparisons versus Year Ago

Regards,

Piet Hein

Community Browser