topic Re: Trigger to select dates in QlikView

Trigger to select dates

johnan — Sat, 16 Nov 2024 01:07:37 GMT

Hi,

I have an QV that shows productiondata. When i open the QlikView it will select current date to me via triggers when open.

Type: (Select in field)
Date
=Date(today())

Now to my question, i want to add todays date (as above) and tomorrows date simultaneously, how can i do that in triggers?

Br John

Re: Trigger to select dates

jochem_zw — Thu, 05 Mar 2020 14:07:25 GMT

I would create a variable:

vSelDate='('&chr(39)&date(today())&chr(39)&'|'&chr(39)&date(today()+1)&chr(39)&')'

on the Action, search string put '=vSelDate'

Re: Trigger to select dates

johnan — Thu, 05 Mar 2020 14:22:39 GMT

Hello,

I got a - if i print out vSelDate in a textbox

It seems that incorrect?

Re: Trigger to select dates

jochem_zw — Thu, 05 Mar 2020 14:26:21 GMT

It should show:

Re: Trigger to select dates

johnan — Thu, 05 Mar 2020 14:40:02 GMT

Thanx, now i got the dates 🙂

I even tried with a button but no success.
Se below 🙂

Re: Trigger to select dates

jochem_zw — Thu, 05 Mar 2020 14:46:56 GMT

no succes? is your variable VSelDate or vSelDate?

Re: Trigger to select dates

johnan — Mon, 09 Mar 2020 07:02:41 GMT

Hi, no success.

It's VSelDate and i got it in the textbox. But it can't choose it with the trigger 😞

Re: Trigger to select dates

Brett_Bleess — Thu, 02 Apr 2020 12:39:07 GMT

Only alternate test of which I can think would be to try the Toggle Select Action in the Button object to see if that will work or not, as if not, then I suspect there may be a defect potentially...

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Button2.htm#anchor-4

Click the Add Action dialog link on the right side of the page to take you to the list of Actions, then check details on Toggle Select...

Regards,
Brett