Creating a variable filter from a table

Roop — Fri, 27 Sep 2024 13:15:35 GMT

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

Re: Creating a variable filter from a table

zar — Tue, 08 Oct 2024 18:47:37 GMT

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.

topic Re: Creating a variable filter from a table in App Development

Creating a variable filter from a table

Re: Creating a variable filter from a table