Passing GetFieldSelections to a variable

markabrom — Thu, 12 Sep 2019 15:26:31 GMT

I have a requirement where I need to pass a value from a filter into a dimension and then have the data sorted using an >= operator.

The data is a Fiscal Year column and if a 2015 value is selected in a filter I need to see only Fiscal Years that are greater than or equal to 2015.

So if I hard code the value 2015 as below, I get the correct results.

=if (FISCAL_YEAR >= 2015, FISCAL_YEAR)

it correctly returns

Fiscal_year
2015
2016
2017
2018
2019
2020

If I create a variable called v_fy with a hardcoded value of 2018

and use

=if (FISCAL_YEAR >= $(V_FY), FISCAL_YEAR)

This also works correctly

Returns
2018
2019
2020

Now the issue is when I assign the v_fy variable with a value of

=GetFieldSelections(FISCAL_YEAR)

and use the same

=if (FISCAL_YEAR >= $(V_fy), FISCAL_YEAR)

I then goto the filter and choose 2015, the only row I will get is:

2015

Why can't I see the other values when I use the GetFieldSelections with a variable?

Re: Passing GetFieldSelections to a variable

dplr-rn — Thu, 12 Sep 2019 15:57:27 GMT

I am assuming the Date filter is not on Fiscal year.
This is happening because qlik filters all values with that year. You will need to use set analysis in your table.
e.g. Your filter is on orderyear
Sum( {<OrderYear=,FiscalYear{">=$(=V_fy)"}>} Sales)

topic Passing GetFieldSelections to a variable in QlikView

Passing GetFieldSelections to a variable

Re: Passing GetFieldSelections to a variable