Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

siddharthsoam
Contributor

Select minimum value from fiscal year

I  want to select minimum value from my fiscal year column FY16 and FY17 and store it in a variable. But then when I select a value in the fiscal year filter the variable's value gets changed

1 Solution

Accepted Solutions
shraddha_g
Honored Contributor III

Re: Select minimum value from fiscal year

if you want to fix this value and should not affect from any selection then you can use

Max({1}YearField)

Use it according to your expression

5 Replies
shraddha_g
Honored Contributor III

Re: Select minimum value from fiscal year

if you want to fix this value and should not affect from any selection then you can use

Max({1}YearField)

Use it according to your expression

ali_hijazi
Honored Contributor

Re: Select minimum value from fiscal year

create a variable and in let the definition starts with = sign

and the definition would look like something like this:

=Max({1}year)

where {1} is the whole set of data regardless of any selection you make on the dashboard

siddharthsoam
Contributor

Re: Select minimum value from fiscal year

Hi Shraddha,

Its working fine the value of my variable is fixed, but due to this other filter selections are not working.

ali_hijazi
Honored Contributor

Re: Select minimum value from fiscal year

can you share a sample application to investigate it

shraddha_g
Honored Contributor III

Re: Select minimum value from fiscal year

Max({<YearField=>}YearField)

Community Browser