topic Difference between Full year view and Year to Date View in QlikView

Difference between Full year view and Year to Date View

Tue, 06 Mar 2012 12:20:30 GMT

Hi All,

Can some one tell me the difference between FullYear View(FYV) and YeartoDate View(YTD). I need to create a button in which I have to show the respective data (FYV or YTD) based on User selection

Thanks,

Lavanya

Difference between Full year view and Year to Date View

jagan — Tue, 06 Mar 2012 12:30:38 GMT

Hi,

FullYear View displays the data for all the months Jan-Dec, mostly this is used for past years.

YearToDate means Year starting (Jan 1 of current Year) to Current date.

Suppose if the year selected is 2012 then you have to use YTD, otherwise use FullYear view.

Regards,

Jagan.

Re: Difference between Full year view and Year to Date View

Tue, 06 Mar 2012 12:34:57 GMT

So If I need to show the same in a button where the button toggles from YTD and FYV..

For FYV : I will select all the months (Jan - Dec)

For YTD : How do I make the selections.. Can u help me with some example??

Thanks in advance..

Difference between Full year view and Year to Date View

jagan — Tue, 06 Mar 2012 12:53:15 GMT

Hi,

Please explain in detail what you require with example.

Regards,

jagan.

Re: Difference between Full year view and Year to Date View

Tue, 06 Mar 2012 13:13:36 GMT

Hi,

I have a button in my application which helps the user to toggle from Full Year view to Year to Data view.. As you said I will make all the months selected in the Month in triggers for Full year view.If I have to implement the same in triggers for YTD view how do I select the data for the latest availablle month.I mean how do I implement the same in Triggers for YTD..

Difference between Full year view and Year to Date View

jagan — Tue, 06 Mar 2012 13:55:30 GMT

Hi,

There is no need to write any Triggers to select the months, you can simply manage it with expression

FullYear = Sum({<Year={'$(=Max(Year))'}, Month=, Quarter=, Week=>} Sales)

Calculates sales for the whole year, we are excluding the Month, Quarter and Week selections.

YTD = Sum({<Month=, Quarter=, Week=, Date={'>=$(=YearStart(Max(DateField))) <=$(=Today())'}, >} Sales)

Calculates sales for the Jan 1, to current date.

Regards,

Jagan.

Re: Difference between Full year view and Year to Date View

Wed, 07 Mar 2012 09:37:41 GMT

Hi,

Hope I have not clearly explained you my requirement.I have year,month list box on the top of the sheet.When the user clicks the button (which has both YTD and FYV i.e the values are toggled based on the condition (if (vcondition = 0,'YTD',Full Year') & 'View'. let's suppose if the user has seleted 2012 so data will be present on till Feb so the month field show get the Jan & Feb values for YTD view and Jan to Dec for Full Year view..

Hope i have explained you clearly..

Thanks

Difference between Full year view and Year to Date View

vijay_iitkgp — Wed, 07 Mar 2012 09:43:19 GMT

H Lvanya,

For current Year Full year and Ytd will be same because you have data it date only. Now coming to your question if you select year 2011 and month May then your YTD will so data from 2011 Jan to May however Full year will show data for complete 2011. You can easily achiev this by set analysis.

Hope I am able to explain you.

regards

Vijay

Difference between Full year view and Year to Date View

jagan — Wed, 07 Mar 2012 10:12:45 GMT

Hi,

Can you attach the sample file.

Regards,

jagan.

Re: Difference between Full year view and Year to Date View

Wed, 07 Mar 2012 10:27:05 GMT

Hi,

Sory I could not attach the file bcz of its size.. I just a want a button in which if the user click 2012( all the possible months for the year should be selected i.e for 2012 - Jan,Feb,March till date).. This is my requirement..

Thanks

Re: Difference between Full year view and Year to Date View

jagan — Wed, 07 Mar 2012 10:53:09 GMT

Hi,

Please check the attached file.

Hope it helps you.

Regards,

Jagan.

Re: Difference between Full year view and Year to Date View

Wed, 07 Mar 2012 12:15:04 GMT

Hi Mohan,

Thanks for taking some time to prepare the sample dashboard..

Regards,

Lavanya