Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Roop
Specialist
Specialist

Creating a variable filter from a table

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

Labels (1)
1 Reply
zar
Employee
Employee

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.