Set analysis calculated variable

[Qlik-A-Holic]

Hi everyone,

my second post.

I have a ytd table with set analysis to calculate the ytd based on the selected month.

As seen I selected the Dec.

I used a fiscal year starting at Oct.

The set analysis is:

SUM({<Kategorie={'Instore'},[Auftragsdatum.aC.Date]={"<=$(=max([Auftragsdatum.aC.Date]))"}, [Auftragsdatum.aC.Month]=>}[Versand nach Retouren Netto])

In the right column i calculate max() of the date.

The dimension is FiscalYear

When i select Dec, the max(date) shows correctly, but the YTD calculted only the max(date) of all dates and not per Dimension (=FiscalYear)

Can I let the calculated variable calulate by dimension "on-time"?

Thanks

[Anil_Babu_Samineni]

We must mapped Fiscal table to Fact Date table, Then only it will associate each. I apologies, If i misunderstand the requirement.