topic Passing parameters to Access Point URL to override OnActivate sheet tigger in QlikView

Passing parameters to Access Point URL to override OnActivate sheet tigger

kshirtan — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I am well aware of passing parameters to Access Point URL, but I am facing the following issue.

If I have a List Box containing some Report names, I pass &sheet=SH100&select=LB01,'ReportName1'

The problem is the OnActivate Sheet Trigger. I want a default selection to be made if nothing is selected.

However, this is overriding my list box selection in Access Point URL.

Eg:-

OnActivate Sheet trigger:-

Field name:- Dynamic_ReportName

Search String:- IF(MATCH(Dynamic_ReportName, 'ReportName1'), 'ReportName1', 'ReportName2')

OnLeave Sheet Trigger:-

Clear Field:- Dynamic_ReportName

Even when i hit the URL with &sheet=SH100&select=LB01,'ReportName1' it goes to ReportName2 and on refreshing the webpage,

it selects ReportName1.

This problem is scalable to multiple reportnames (say, 😎 under a sheet.

Re: Passing parameters to Access Point URL to override OnActivate sheet tigger

sasiparupudi1 — Fri, 23 Mar 2018 10:27:34 GMT

May be try the search string like

IF(SubStringCount(GetFieldSelections(Dynamic_ReportName,','), 'ReportName1')>0, 'ReportName1', 'ReportName2')

Re: Passing parameters to Access Point URL to override OnActivate sheet tigger

kshirtan — Mon, 26 Mar 2018 13:51:00 GMT

Hi Sasidhar,

I used the search string like you suggested:-

=IF(SubStringCount(GetFieldSelections(Dynamic_ReportName), 'ReportName1')>0, 'ReportName1', 'ReportName2')

The problem that I am facing is that the the URL is not picking the parameter passed for the sheet I open first.

But it works fine for the successive sheets that I open.

I tried the following solutions:-

Use Field event Triggers:-

OnSelect :- GetFieldSelections(Dynamic_ReportName)

and

OnChange :-

(1) Clear Field:- Dynamic_ReportName

(2) Select in Field :- GetFieldSelections(Dynamic_ReportName)

and I am passing the URL as:-

&sheet=SH100&select=LB01,'ReportName1'&select=LB01,'ReportName1'

So that it would work due to Onchange field atleast for the 1st tab.

Also, I read that for AJAX, the OnActivate trigger or Document event Triggers don't work.

That doesn't seem to be the case for me as it works for all the sheets I open after my first sheet (all through URL with parameters for sheet id and listbox selection).

Any advice would be much appreciated.

Thanks,

Tanmay.