Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
This expression is not working in QVSense
(Sum({$<FinancialYear=,FiscalYear={$(=max(FiscalYear)-1)}, Quarter=
,[Posting Date]={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-1,4))<=$(=addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12))"}
>} [ Sales ])
What is Posting Date's format in Qlik Sense? Is it different then what is set during the reload in the environmental variables? If it is, then you might need to use Date() function in your set modifier
Sum({$<FinancialYear=,FiscalYear={$(=max(FiscalYear)-1)}, Quarter=
,[Posting Date]={">=$(=Date(YearStart(Max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-1,4), 'DateFieldFormatHere'))<=$(=Date(AddMonths(Max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12), 'DateFieldFormatHere'))"}>} [ Sales ])
Also, check this link out:
Try
Sum({$<[Posting Date] ={">=$(=Date(YearStart(max([Posting Date]),-1,4)))<=$(=date(addmonths(max([Posting Date]),-12)))"}, FinancialYear=,FiscalYear=,Month=,Quarter=>} [ Sales ])
I tried but it is not working
share a sample app if possible
What is Posting Date's format in Qlik Sense? Is it different then what is set during the reload in the environmental variables? If it is, then you might need to use Date() function in your set modifier
Sum({$<FinancialYear=,FiscalYear={$(=max(FiscalYear)-1)}, Quarter=
,[Posting Date]={">=$(=Date(YearStart(Max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-1,4), 'DateFieldFormatHere'))<=$(=Date(AddMonths(Max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12), 'DateFieldFormatHere'))"}>} [ Sales ])
Also, check this link out: