Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
I confirm, I just tried something similar and it works.
Enjoy your Qlik.
Kind regards,
Théo ATRAGIE.
Thanks Mark. That did the trick.
Regards,
Brian
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?