Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

pduplessis
New Contributor II

Set Analysis help with Slider

My data model contains a MonthYear field, and a coresponding rolling month counter field called Month#. I have a slider, and want to create a text box that informs the user what range of dates are included in their selection.

I tried =minstring(subfield(GetFieldSelections(MonthYear, ',',24), ',')) but of course that returns the alphbetically first MonthYear, not the chromological minimum.

So I thought something like this might work:

only({<Month#={$(=min(Month#))}>}(subfield(GetFieldSelections(MonthYear, ',',24), ','))) for the min and

only({<Month#={$(=max(Month#))}>}(subfield(GetFieldSelections(MonthYear, ',',24), ','))) might work for the maximum.

but for some strange reason, they both return the same value, the min?

can anyone help?

Message was edited by: pduplessis Never mind. I simplified and went with MonthName(only({$<Month#={$(=min(Month#))}>}Date)) &' to '& MonthName(only({$<Month#={$(=max(Month#))}>}Date))  which works.

Community Browser