Trigger for Last FY

[helen_pip]

Dear Qlikview user

I have created a field called fiscal year which is stored into a QVD

Yearname(TempDate, 0, 4) AS FiscalYear

I load this field into a susequent QVW and create a list box

I.e.

2015-2016  2016-2017 2017-2018 2018-2019

My dataseet is always 2 months behind so want to create a trigger on opening page so that the last Financial year is always selected, but I would like the list box to highlight in green the relevent FY

I have been playing around with variables such as:

Text(if( MakeDate(year(today(0)),04,01) <= today(0)-365,   Text((MakeDate(year(today(0)),04,01))),   Text((MakeDate(year(today(0))-1,04,01)))  ))

and although I can get the correct FY to show, it is not highlighted in the Qlik green

Could someone kindly point me in the right direction, as I think my variable needs to be translated to a string format

[sunny_talwar · Accepted solution]

Add another action

Select Possible -> FY (or FiscalYear) field

[helen_pip]

Dear Sunny

Thank you for your response.  This action does highlight the FiscalYear field in green

Is it a matter of ordering my actions, so the Current FiscalYear is selected on opening page?

Kind Regards

Helen

[sunny_talwar]

Is it a matter of ordering my actions, so the Current FiscalYear is selected on opening page?

Not sure I understand? what exactly are you asking?