topic Re: How to see previous YTD values using set analysis and automatically taking into selection for the previous year not selected periods and days but associated in the current year in QlikView

How to see previous YTD values using set analysis and automatically taking into selection for the previous year not selected periods and days but associated in the current year

Wed, 04 Dec 2013 10:21:47 GMT

Dear QVCommunity,

I can't find a way to show previous year amounts based automatically only on the year selection. For example, if I select a year and have Jan-Mar data in current year I would like to show amounts for the previous year only for Jan - Mar, without extra selecting periods and days.

Thx

Re: How to see previous YTD values using set analysis and automatically taking into selection for the previous year not selected periods and days but associated in the current year

Wed, 04 Dec 2013 10:58:20 GMT

Check a document I have written a few weeks ago:

http://community.qlik.com/docs/DOC-4821

You can use also Set Analysis but it will be more complicated, especially for YTD.

Fabrice

Re: How to see previous YTD values using set analysis and automatically taking into selection for the previous year not selected periods and days but associated in the current year

MK_QSL — Wed, 04 Dec 2013 10:59:37 GMT

Please check enclosed file...

Re: How to see previous YTD values using set analysis and automatically taking into selection for the previous year not selected periods and days but associated in the current year

Wed, 04 Dec 2013 11:05:58 GMT

Manish,

Your example is fine. For my case you miss a period, for example. Please check my example.

Re: How to see previous YTD values using set analysis and automatically taking into selection for the previous year not selected periods and days but associated in the current year

MK_QSL — Wed, 04 Dec 2013 11:06:45 GMT

where is your example?

Re: How to see previous YTD values using set analysis and automatically taking into selection for the previous year not selected periods and days but associated in the current year

Wed, 04 Dec 2013 11:11:33 GMT

In my question

Re: How to see previous YTD values using set analysis and automatically taking into selection for the previous year not selected periods and days but associated in the current year

MK_QSL — Wed, 04 Dec 2013 11:46:12 GMT

Hope this file will help you

Re: How to see previous YTD values using set analysis and automatically taking into selection for the previous year not selected periods and days but associated in the current year

Wed, 04 Dec 2013 12:03:44 GMT

This is the outcome I already have.

Using your example here is the incorrect amount:

And here is the correct one. To get it I need to select Months and days if months is not over yet:

And my question was if I can get the correct amount for previous year without selecting Months in this case.

Thx

Re: How to see previous YTD values using set analysis and automatically taking into selection for the previous year not selected periods and days but associated in the current year

MK_QSL — Wed, 04 Dec 2013 12:10:27 GMT

Finding difficulties in understanding your question... Could you please upload your example?

Re: How to see previous YTD values using set analysis and automatically taking into selection for the previous year not selected periods and days but associated in the current year

Wed, 04 Dec 2013 12:50:52 GMT

Your example is fine. My question is can I get the amount for 2012 (487680) if I only make two selections: year=2013 and customer=D?

Re: How to see previous YTD values using set analysis and automatically taking into selection for the previous year not selected periods and days but associated in the current year

MK_QSL — Wed, 04 Dec 2013 13:04:42 GMT

Ohh... check file...

Re: How to see previous YTD values using set analysis and automatically taking into selection for the previous year not selected periods and days but associated in the current year

Wed, 04 Dec 2013 13:43:40 GMT

I appreciate your time. It is okay for today and 2013 vs. 2012, but when I select 2012 then I get 372380 for 2011 instead of 374210. This is because you used the system date, today(), so Dec 2011 is excluded and it should be included because 2012 has all 12 months.

Re: How to see previous YTD values using set analysis and automatically taking into selection for the previous year not selected periods and days but associated in the current year

MK_QSL — Wed, 04 Dec 2013 13:53:17 GMT

now ?

Re: How to see previous YTD values using set analysis and automatically taking into selection for the previous year not selected periods and days but associated in the current year

Wed, 04 Dec 2013 14:02:51 GMT

Yes, old years are now fine but now the first case is not. I get 545780 for 2012 which is a fully year sale and in the beginning of this exercise you got 487680 which is what I would like to get if possible.

Re: How to see previous YTD values using set analysis and automatically taking into selection for the previous year not selected periods and days but associated in the current year

MK_QSL — Wed, 04 Dec 2013 14:45:16 GMT

Tired 🙂

Re: How to see previous YTD values using set analysis and automatically taking into selection for the previous year not selected periods and days but associated in the current year

Wed, 04 Dec 2013 14:55:04 GMT

It looks okay in your case Thx

Will this work if I have dates as the lowest time level?

Re: How to see previous YTD values using set analysis and automatically taking into selection for the previous year not selected periods and days but associated in the current year

MK_QSL — Wed, 04 Dec 2013 14:59:01 GMT

It should.... Please mark answered if you get your answer...