Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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