topic Input variables before loading in QlikView

Input variables before loading

Anonymous — Wed, 16 Mar 2011 10:47:17 GMT

Dear specialits,

Is it possible to let the load script with input variables?

What I want is that when you open the Qlikview document there will be a input filed to fill in the variable.
Then make a Load-button, when you press the button the loaad script will be using the variabel.

Example:

Input vYear = 2009

And then use vYear in the loadscript like :

Load *
SQL SELECT
FROM TABLE
Where Year = '$(vYear)'

How do I set the variable (vYear) before loading?

Input variables before loading

Wed, 16 Mar 2011 11:43:30 GMT

hi,

i think in qlikview dynamic loading is not possible. am not sure..

one thing u do, load whole data and put in hide mode. when the user give the input as 2009 and clik on a button then we can display the corresponding data.

think it once..

Regards

A'run'

Input variables before loading

Anonymous — Wed, 16 Mar 2011 11:50:32 GMT

Thanks for the reply, nice work around, but that is not going to work for me in this case.
Also I want to use this method to reduce the data, but that is not the mean reason.

Anybody else has an idea?

Input variables before loading

Wed, 16 Mar 2011 11:51:12 GMT

You can do it two ways - using a variable or with an exists test based on the value in an XLS (for example). You may want to try both to see what offers the best performance.

Creating a variable to test against:

tParam:
LOAD Year
FROM paramfile.xls (biff, embedded labels, table is Sheet1$);

LET vYear = peek('Year', 0, tParam);

DROP TABLE tParam;

Load *
SQL SELECT
FROM TABLE
WHERE Year = $(vYear);

or using exists test

tParam:
LOAD ParamYear
FROM paramfile.xls (biff, embedded labels, table is Sheet1$);

Load *
SQL SELECT
FROM TABLE
WHERE exists(ParamYear, Year);

DROP TABLE tParam;

Regards,

Gordon

Input variables before loading

Anonymous — Wed, 16 Mar 2011 11:59:37 GMT

Than ks Gordon,

That is an idea, I am going to take a look at this.

Do you think there is a way to make Qlikviewwrite this varaible to a file?

That way I could make first "page" where the user fills the variable(s)
then make an action which writes the paramfile and then perform the load.

Input variables before loading

Wed, 16 Mar 2011 12:01:54 GMT

....or why not just use an input field with vYear?

I am assuming you are talking about someone reloading the document through QV client because you cannot force a reload through the plugin (at least not directly)...

Input variables before loading

Anonymous — Wed, 16 Mar 2011 12:21:53 GMT

No the Year input is just an example.
I need this variable before loading because when I load all it ruines my data.
This has to do with different formats in different datasources.
I want to get the right information from the right datasource using this input variable.

Input variables before loading

Anonymous — Mon, 04 Apr 2011 11:52:03 GMT

I found what I was looking for in Ralfs Becher's TwitView Qlikview:

Here: http://community.qlik.com/media/p/171902.aspx

This file has a Inputbox where you can enter a variabel and when you reload it uses those variables in to get the wanted information from your datasources.

For those who are interested take a look at the document and see what it does.

Follow vScreenname (vSN) in the script.

Let vSN = lower('$(vScreenname)');

Re: Input variables before loading

Tue, 09 Aug 2016 14:37:59 GMT

Hi everyone,

this might be the solution to what I was looking for. Unfortuntately, the link is not working anymore. Any chance to get the correct link?

Kind regards,

Daniela

Re: Input variables before loading

Tue, 30 Aug 2016 09:47:49 GMT

Hi. I'm in the same boat as Daniela above. Any chance somebody could post a working link for this? It looks to be exactly what i'm looking for.

Regards, Glyn.

Re: Input variables before loading

Wed, 31 Aug 2016 12:13:25 GMT

Hey Glyn,

I added the following to my script and it worked for me.

Let vSystemID=Input('Enter required System ID', 'System ID');

In addition, you have to create your variable (Settings - Variable Overview).

When starting a reload, an Input box pops up before loading any data:

I hope this is helpful.

Regards,

Daniela

Re: Input variables before loading

Thu, 29 Sep 2016 10:25:39 GMT

Thanks very much