Setting Variables as Current Selections Work in Client But Not in AccessPoint

[#1]

In the QlikView client, I have a "Clear All" button set up with the following actions:

Clear All

Set Variable: vStartDate / =Date(today()-14)

Set Variable: vEndDate / =Date(today()+14)

Set Variable: vStartDatePSSD / =Date(today()-14)

Set Variable: vEndDatePSSD / =Date(today()+14)

Select in Field: Network ID / =SubField(OSUser(),'\',2)

When I click this button in the QV client, I get this in the Current Selections box:

When I publish this to AccessPoint and click Clear All, only the Network ID is selected. The dates will change in the corresponding calendar objects (SEE BELOW), but the date ranges won't be "selected" (in that the dates within the range won't be highlighted green) -- which is obvious because if they were selected, they would appear in the Current Selections box (but they don't).

Does anyone know why this would work in the client but not in the browser via AccessPoint? Is this a known issue? I've tried on both Chrome and Firefox.

Thanks,

Kenny

[swuehl]

Any other triggers you are using except the 'Clear All' button? Triggers on variable change?

I am missing the link between your variable modification and the actual Date selection.

(and what are the settings of your calendar objects? I assume the objects are based on variables, not fields)

[#3]

Hi swuehl,

Thanks for the reply. I have an OnOpen trigger with the exact same actions as the Clear All button (except for the actual Clear All action). And, the OnOpen trigger actually works fine (in that the date ranges are pre-selected upon opening the app).

I have two OnSelect field event triggers set for the Original Release Date field:

Set Variable: vStartDate / =MinString([Original Release Date])

Set Variable: vEndDate / =MaxString([Original Release Date])

Same thing for the Product Sales Start Date field (except variable are vStartDatePSSD and vEndDatePSSD).

Also have four OnChange variable event triggers for the four variables mentioned above and all have same value: ='>='&vStartDate & '<='&vEndDate (or ='>='&vStartDatePSSD & '<='&vEndDatePSSD).

Again, all works as I want it in the actual client -- the behavior just doesn't replicate in a browser.

[swuehl]

Ok, just missed the link...

Variable OnChange trigger not working (v11 sr1 &amp; sr2)

[#5]

I didn't follow the discussion you referred me to 100%, but am I to gather that this just won't work unless it's with the IE Plugin?

[swuehl]

Yes, I believe that's a limitation of the Ajax client.

[#7]

Unfortunately, this doesn't appear to be the issue. I can't figure out a way to download the IE Plugin myself (but that's a whole other issue), but I looked at my app on IE on someone else's machine, and I'm seeing the issue on IE as well.

[rwunderlich]

If I follow you correctly, the variables changed by an Action should not fire any subsequent triggers. Can you make the calendar field selections in the actions associated with the button?

-Rob

[#9]

Hi Rob,

I just trying to get the 14 days behind/ahead date range "selected" (i.e., it appears in the Current Selections box like in my screenshot above) when I click the Clear All button. It works perfectly fine in the application, just not when I publish (and apparently not on either the Ajax client or with the IE Plugin). Are you saying I should do a Select in Field action instead of Set Variable? If so, what would be the correct thing to enter for the Search String value to achieve the same effect (selecting 14 days behind as the start of the range and 14 days ahead as the end of the range)?

Thanks!

[rwunderlich]

Use the same expressions you used to set the variables, such as:

=Date(today()-14)