topic Re: Trigger for Last FY in QlikView

Trigger for Last FY

helen_pip — Thu, 17 May 2018 10:13:22 GMT

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

Re: Trigger for Last FY

sunny_talwar — Thu, 17 May 2018 11:05:42 GMT

Add another action

Select Possible -> FY (or FiscalYear) field

Re: Trigger for Last FY

helen_pip — Fri, 18 May 2018 08:26:10 GMT

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

Re: Trigger for Last FY

sunny_talwar — Fri, 18 May 2018 08:52:51 GMT

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?