Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Passing financial year!

Hi All,

How can I pass financial year in to below set analysis instead of year?

sum( {$<YEAR = {$(#=Only(YEAR)-1)}>} Qty )


1 Reply
Highlighted
Not applicable

Hi,

You will have to define Financial Year in a script.

Logic would be:

Say FY-Financial Year, Y-Year for Date-D (02-05-2010) and Month-M

IF M<=3,FY=(Y-1)---Y (IF D=02-03-2010,FY=2009---2010)

IF M>3,FY=Y---(Y+1) (IF D=02-05-2010,FY=2010---2011)

I hope I could convey you logic appropriately.

Happy Thoughts