Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
sreenivas
Creator III
Creator III

Previous monthYear value selection on Current fiscal Year

Hi

How can i get the Previous monthYear selection on Current fiscal Year.

My fiscal year starts from November to October,

Example:

Suppose Fiscal year=2012-2013 selected in the list box, i need to get the value for 2011October .

1 Reply
Not applicable

HI,

Try this

Sum({$<FiscalYear={">=$(=(Min(FiscalYear)-1))"}>}Sal)

Best of luck