Skip to main content
Sept. 27, 10AM ET Do more with Qlik, Insight Advisor – our intelligent AI-assistant in Qlik Sense: Register
Showing results for 
Search instead for 
Did you mean: 
Partner - Contributor III
Partner - Contributor III

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.

0 Replies