Set Analysis help with Slider

pduplessis — Tue, 04 Oct 2011 13:34:50 GMT

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.

topic Set Analysis help with Slider in QlikView

Set Analysis help with Slider