Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Add another action
Select Possible -> FY (or FiscalYear) field
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
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?