topic Re: YTD Calculation in QlikView

YTD Calculation

Anonymous — Fri, 02 May 2014 20:49:31 GMT

Hi,

I want to calculate the YTD values and populate in a combo chart.

Find below the image which is the calculation in a spreadsheet.

Jan - NIL

Feb - Monthly Actuals(Jan) - $3,220

Mar - Monthly Actuals(Jan+Feb) - ($3,200+2,995).=$6,175..

Montly Actuals are calculated with the dimensions. Now the issue is with the YTD Labor Actuals.

Please suggest an idea to pull the values from Feb month in Qlikview expression as per the below snapshot. Thanks.

Re: YTD Calculation

its_anandrjs — Fri, 02 May 2014 21:20:16 GMT

For YTD calculation use like below

Eg:-

=Sum({$<YourDatefield = {'>$(=Max((YearStart(Today())))) <=$(=Max(today()))'}>} Value)

Re: YTD Calculation

Anonymous — Sat, 03 May 2014 02:52:21 GMT

I didnt get the correct result for the above set analysis.

The spreadsheet calculation is different from the actual YTD formula.

Can you please explain in brief, if the above set analysis can be applied for my case.

Re: YTD Calculation

vikasmahajan — Sat, 03 May 2014 04:54:41 GMT

Request you to refer master calender SIMPLE MASTER CALENDER , Please implement the same in your data model and give following formula for calculating YTD.

SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},MonthName=,Quarter=

,[Posting Date]={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}

>}[Sales Amount])

Hope this help you to calculate ytd.

Vikas