Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor III

Select a range on slider on open

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?

1 Reply
Highlighted

Re: Select a range on slider on open

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)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)