topic Re: Select a range on slider on open in QlikView

Select a range on slider on open

greend21 — Wed, 25 Nov 2020 16:16:04 GMT

I have a date selection slider in my application that selects a range of 5 quarters. I want it to default to the most recent five quarters upon opening.

My slider expression is =ReportDtSlider and I tried using this in the On Open>Select in Field trigger as my field with Max(ReportDtSlider) as my Search String but am having issues getting it to even select one date, let alone a range. Do you have any advice on how to get this to function correctly?

Re: Select a range on slider on open

Anil_Babu_Samineni — Tue, 12 Dec 2017 17:35:01 GMT

Try to give it as this?

Num(Month(ReportDtSlider)) as DateNum

'Q' & Ceil(Month(ReportDtSlider)/3) as Quarter,

And then, Finally DateNum is the field in trigger

And string is

=Only({<Quarter = {">=$(=Num(QuarterStart(Max(DateNum)-5)))<=$(=Max(DateNum))"}>} Quarter)