Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
greend21
Creator III
Creator 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
Anil_Babu_Samineni

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)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful