Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Previous year expression in not working in Sense

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 ])

1 Solution

Accepted Solutions
sunny_talwar

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:

Dates in Set Analysis

View solution in original post

4 Replies
shraddha_g
Partner - Master III
Partner - Master III

Try

Sum({$<[Posting Date] ={">=$(=Date(YearStart(max([Posting Date]),-1,4)))<=$(=date(addmonths(max([Posting Date]),-12)))"}, FinancialYear=,FiscalYear=,Month=,Quarter=>} [ Sales ])

Anonymous
Not applicable
Author

I tried but it is not working

shraddha_g
Partner - Master III
Partner - Master III

share a sample app if possible

sunny_talwar

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:

Dates in Set Analysis