Set analysis calculated variable

Qlik-A-Holic — Wed, 30 Jan 2019 22:19:45 GMT

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

Re: Set analysis calculated variable

Anil_Babu_Samineni — Thu, 31 Jan 2019 01:07:16 GMT

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