topic How to pass a parameter to ZFC application? in QlikView

How to pass a parameter to ZFC application?

Mon, 26 Jan 2026 18:19:17 GMT

There is an old thread explaining how to pass a parameter to a ZFC based application, but the actual code is hidden in that post!

It seems like onOpen document event macro is not being called when the application is accessed thro ZFC.

Can someone suggest an alternate way of achieving this? Appreciate any help..

How to pass a parameter to ZFC application?

Wed, 24 Jun 2009 15:40:41 GMT

Hi!

You just have to do some javascript!

In the default.htm you add:


function init(key, name)
{
 var val = Qva.ExtractProperty(key);
 if(val) qva.Set(name,'text',val,false);
}

 init('param','LB01');

Your URL is then something like http://server/AJAXApplication/default.htm?param=Customer1 where LB01 is the ID of your listbox and "Customer1" the value you want to select.

See attachment for details!
Things can become more complicated if you want to hand over multiple values and/or lock your selection. But for simply passing the parameter this should be fine..

How to pass a parameter to ZFC application?

Wed, 24 Jun 2009 22:12:26 GMT

Thanks rva! That really helped.. 2 more qns!

1) Is there a way to set a QlikView document variable through Javascript?

2) Where can I find more information about these available functions like Qva.ExtractProperty?

Thanks again...

How to pass a parameter to ZFC application?

Wed, 24 Jun 2009 23:58:40 GMT

One more problem!

It seems that in order to use avqSet, the list box has to be in show mode. I created a list box of id column and made it hidden so that other application can pass id parameter and i could set it up on the list box. So far i found that when i use avqSet on hidden list box, it gives an error as - Server Error, Session timed out, reconnecting... and keeps giving the same error messages even though i press ok. I have to kill the IE process!

So is there any way to use hidden list boxes and be able to set values in those?

Appreciate any help...

How to pass a parameter to ZFC application?

Thu, 25 Jun 2009 02:55:27 GMT

I would do it a different way:

Instead of setting the listbox hidden in QlikView, I modify the HTML-Code generated for the AJAX-Client.

Go to the .htm file
Locate the listbox you want to hide
add in the CSS-style of the tag visibility:hidden

So the enduser does not see the listbox, but you can set a value through avqSet.

For your other questions:

I don't know any official documentation. However you have all the Javascript libraries installed with your QlikView server. So take a look at the Javascript files to understand more about it.

I don't know if you can set a variable directly. But probably you can set an InputBox which then sets an variable!

How to pass a parameter to ZFC application?

mellerbeck — Thu, 25 Jun 2009 05:27:23 GMT

Do you know if it is possible to use the init('param','LB01') with something like a table box or a chart??

so like init('param','CH03') or init('param','TB01')

etc....

Thank you for any clues!

How to pass a parameter to ZFC application?

Thu, 25 Jun 2009 20:40:58 GMT

Thanks rva.

I solved the problem by making height and width as 0 points in the html for the list boxes which I want to hide. Although visibility:hidden seems to be a better way of doing it.. will check that out..

Now, a fundamental problem.. client (IE) calls this AJAX based QlikView app by using http://xxx.com/ajax/SH09.htm?userid=xxxx&param=value

The ajax page extract the param, set the value in list box, and the data is presented based on the selection of param field. Now, if IE window is refreshed, same process is repeated again, and based on default behavior of QlikView, instead of setting the param value, it deselects it !! So the client gets to see the whole data !!

I might have to disable IE "Refresh" completely. (atm, not sure if thats possible) But do you have any other ideas that you can suggest? Apart from browser refresh, there may be other ways of deselecting the param value and exposing the whole data. So would like to fix it at the root itself.

How to pass a parameter to ZFC application?

Thu, 25 Jun 2009 20:45:44 GMT

Btw, will not be able to implement Dynamic Data Reduction for the above issue. Our QV app will be opened to other multiple apps within the company. Other apps need bits and pieces from our QV app. As such, upfront we dont know the incoming users and their security level so cant restrict the data by using section access. The only way for us is to enforce other apps to pass on filter criteria and we will present the data based on the filters passed. Afterwards, client should not be able to navigate anything apart from the data presented in the beginning..

How to pass a parameter to ZFC application?

Fri, 26 Jun 2009 14:47:14 GMT

@mellerbeck:

I don't see any reason why to do that!
Filtering data in Qlikview always happens through listboxes. So setting a value in a listbox will always cause your chart, table box to update to the current selection.

If you don't want to show the listbox, see the postings above. Just hide the listbox with CSS visibility:hidden; in the HTML-Code.

How to pass a parameter to ZFC application?

Fri, 26 Jun 2009 14:52:44 GMT

May this code example helps. Instead of setting the parameter in the default.htm I once did the following at <body>-onload on the SH01.htm

It also locks the selection, so this is some way where a user can not leave this selection that easy.


function QueryAndLock()
 {
 try
 {
 accountValue = Qva.ExtractProperty ("AccountName");
 if (accountValue.length > 0)
 {
 // needed to replace Blanks, as Salesforce delivers these as "+"
 accountValue = accountValue.replace("+"," ");
// alert (accountValue);
 // Unlock the listbox
 qva.Set("Document.LB95.ULC", "action", "", true);
 // clear the listbox
 qva.Set(".LB95", "search", "*", true);
 qva.Set(".LB95", "closesearch", "accept", true);
 // query fro the right account
 qva.Set(".LB95", "search", accountValue, true);
 qva.Set(".LB95", "closesearch", "accept", true);
 // lock the listbox
 qva.Set("Document.LB95.LOC", "action", "", false);
 }
 }
 catch (e)
 {
// alert ("no matching parameters");
 }
 }

How to pass a parameter to ZFC application?

Mon, 29 Jun 2009 22:17:57 GMT

rva - thanks again!

JavaScript code to lock the listbox selection did the trick. After putting the javascript the browser refresh issue is fixed. Now the only way for a user to get an access to complete data is by passing incorrect data - for example, a value that does not exist in the list box. In that scenario, user gets to see everything.. thats not a big issue atm. We will be able to put some work around..

thanks for all the help...

How to pass a parameter to ZFC application?

Tue, 06 Oct 2009 04:50:52 GMT

Hi,

The code did a select but not a lock.
Is there a way to lock?

I using th 9 sr 1 version on QVS and QV.

I cant find the docs for the qva script code... Is there any? or is the .js files the "doc"?

BR Hans