last year month figure display in current month

[gzboy008]

Hi forum, I'm in a deep puzzle.

Hope someone can lend me a hand. Thanks in advance!

Here's the story. I have the testing data as below.

When I press apply filter button. it will set the filtering to retrieve data from 1/1/2014 ~ 2/15/2014.

How can I retrieve the last year figure and display at the same line.

Below's what I expected.

[crusader_]

Hi Kelvin,

PFA. According to this data model it's max I can achieve.

I can suggest you to use Master Calendar in your application and look through this article.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd

Hope this helps.

Andrei

[Anonymous]

Hi,

    Chk the attached App.

    Tatz all i cud do to get wat u nided.....

Regardz,

Vaibz 😉

[SunilChauhan]

see the attched and create your idea as per this sample

[gzboy008]

Hi Andrei,

Thanks for your reply.

But I don't want 2013's figure show in the chart.

[gzboy008]

Hi,

Thanks for reply.

I don't want them in different objects.

Any ideas?

[gzboy008]

Hi chauhans85,
Thanks for reply.

I don't want them in different objects.

[#8]

Hi,

I simply changed Andrei's Version and added a Month Field in skript.

THen we use the month as dimension and you can see the values for the current and the last year separately.

See qvw attached...

Hope this is what you were looking for.

Kind regards,

Anthony

[#9]

Hi,

I simply changed Andrei's Version and added a Month Field in skript.

THen we use the month as dimension and you can see the values for the current and the last year separately.

See qvw attached...

Hope this is what you were looking for.

Kind regards,

Anthony

[gzboy008]

Hi Anthony,

I need to have year & month in dimension, as I will have cross year data. So only have months in dimension is not enough. Thanks for your idea. Any other thoughts?