topic YTD for fiscal previous year in QlikView

YTD for fiscal previous year

ferha_jafri — Thu, 19 Dec 2013 05:07:32 GMT

Hello Everyone,

I have issue with YTD fiscal year which starts from jul to june the issue is that when i writing YTD expression the dates are showing fine but when i am checking for it for previous year the values are not mathich.

Re: YTD for fiscal previous year

sujeetsingh — Thu, 19 Dec 2013 05:09:57 GMT

Can you post a sample !!

Re: YTD for fiscal previous year

vikasmahajan — Thu, 19 Dec 2013 06:31:50 GMT

Hii Ferha,

try following expression

SUM({$<FiscalYear={$(=max(FiscalYear)-1)},YEAR_MONTH=p(YEAR_MONTH_PREVIOUS),[Posting Date]={'<=$(vLMaxDate)'},FinancialYear=,MonthName= >} [Sales Amount])

1. YEAR_MONTH_PREVIOUS is filed to create in calender master is as follows

num((Year(TempDate)-1)&num(Month(TempDate),'00')) AS YEAR_MONTH_PREVIOUS, // Link between tables for previous month / year selection

2. vLmaxdate is variable

=date(addyears(max([Posting Date]), -1), 'DD/MM/YYYY')

Hope this helps you for previous year ytd vs curr year ytd ( Like wise comparison)

Vikas

Re: YTD for fiscal previous year

ferha_jafri — Fri, 20 Dec 2013 05:33:12 GMT

thanks for everyone's reply.