Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
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
Master III
Master III

May be try the search string like

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

Contributor
Contributor

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.