Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
kshirtan
New Contributor

Passing parameters to Access Point URL to override OnActivate sheet tigger

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.

2 Replies
sasiparupudi1
Honored Contributor III

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

May be try the search string like

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

kshirtan
New Contributor

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

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.