topic Re: Setting Variables as Current Selections Work in Client But Not in AccessPoint in QlikView

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

Tue, 14 Jul 2015 20:33:35 GMT

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

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

swuehl — Tue, 14 Jul 2015 20:55:46 GMT

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)

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

Tue, 14 Jul 2015 21:15:51 GMT

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.

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

swuehl — Tue, 14 Jul 2015 21:25:02 GMT

Ok, just missed the link...

Variable OnChange trigger not working (v11 sr1 & sr2)

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

Tue, 14 Jul 2015 21:45:21 GMT

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?

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

swuehl — Tue, 14 Jul 2015 22:02:27 GMT

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

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

Wed, 15 Jul 2015 20:22:38 GMT

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.

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

rwunderlich — Wed, 15 Jul 2015 22:38:40 GMT

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

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

Wed, 15 Jul 2015 22:45:31 GMT

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!

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

rwunderlich — Thu, 16 Jul 2015 00:30:42 GMT

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

=Date(today()-14)

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

Thu, 16 Jul 2015 15:12:51 GMT

Hi Rob, thanks for the response. This isn't working for some reason. I just did four Select in Field actions on the a new button (with the same four +/-14 days values), and all that does is display today's date for the calendar objects and it only "selects" the current day for one of the fields (the "Product Sales Start Date"). Really makes no sense to me. It's not critical that I get this to work, so I think I'm just going to move on from this. I was hoping it would be a quick solution. Thanks for everyone's input!