Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to select the starting month for a financial year and this can change in my data.
I have a table with the starting month of the financial year as a list February through to December in a field called InYearMonthChange.
I want select a value of InYearMonthChange and display the respective month value in the filter.
I get the following results:
= 'March' in the field for the listbox and this works and gives the values for the March fields
= GetFieldSelections(InYearMonthChange) gives the value March
= Chr(39) & GetFieldSelections(InYearMonthChange) & Chr(39) gives the value 'March'
Any idea how I can do this to use a filter to define another variable filter?
Many thanks in advance
Can you please explain your goal a little more? From what I see you want to work with something similar to https://community.qlik.com/t5/New-to-Qlik-Analytics/calendar-year-to-fiscal-year/td-p/1253798 with fiscal year that changes. Maybe you are even interested in have YTD measure. You can use variable input box to define the variable to start your year and use that variable in the expression. If you can provide more info we may help better.