Skip to main content
Announcements
Join us on Feb.12 to Discover what’s possible with embedded analytics: REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Brip51
Creator
Creator

Select Date Range Action in Button

Hi,

I am trying to create a button that will select a date range using an action.  I set up the button with action "Select values in a field" and set the field to "Booking Date"  

I want to select dates greater than or equal to the date that is selected in the 'To Booking Date' Field.

I can get it to select a single date in the "Booking Date" field using  =[To Booking Date] in the expression value.

I have tried ='>='&[To Booking Date] to get the range but that does not work.  I have tried =concat('>=',[To Booking Date]) and that does not work.

I am not sure where my syntax is going wrong.  

Any help on this would be appreciated.

Thanks,

Brian

 

 

Labels (2)
1 Solution

Accepted Solutions
marksouzacosta

hi @Brip51 ,

Try to replace your Action with "Select values matching search criteria".
Your ='>='&[To Booking Date] should work fine.

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com

View solution in original post

4 Replies
marksouzacosta

hi @Brip51 ,

Try to replace your Action with "Select values matching search criteria".
Your ='>='&[To Booking Date] should work fine.

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com

theoat
Partner - Specialist
Partner - Specialist

I confirm, I just tried something similar and it works.

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

Brip51
Creator
Creator
Author

Thanks Mark.  That did the trick.

Regards,

Brian

 

AshrafTai
Contributor III
Contributor III

I have an issue with this, it is working but I have to click the Button twice to make it work. how can I fix the problem?