topic Re: Pass parameters when loading script for QVW in QlikView

Pass parameters when loading script for QVW

Wed, 20 Aug 2014 14:15:43 GMT

Is it possible that parameters can be passed into a QVW when it is being reloaded. What I am looking to do is have the ability to load data for a given period, say 1st April 2014 to 31st July 2014. Come say mid September, i want to load up to Aug 14. The idea behind this is that I may want to reload data in Aug, but I dont want the period to change.

Re: Pass parameters when loading script for QVW

Wed, 20 Aug 2014 14:24:12 GMT

Hi there,

Any number of parameters can be passed into the QVW right before the reload by using the above option. You can create two variables vStart and vEnd in your script and using the above you can pass values to those variables.

Thanks

Re: Pass parameters when loading script for QVW

Wed, 20 Aug 2014 14:35:08 GMT

In my reload I dont have that option. Must be version? Im on QV11

Re: Pass parameters when loading script for QVW

Wed, 20 Aug 2014 14:46:27 GMT

Mine is QV11 as well. Can you share your screenshot?

Re: Pass parameters when loading script for QVW

martynlloyd — Wed, 20 Aug 2014 14:59:46 GMT

Hi, I use a qvs file and the INCLUDE statement.

I can even write parameters into the qvs file using another script

Example

Parms:

LOAD

'Set vMyParm = Setting1' as Param1

Autogenerate;

Store Parms into Config.qvs (txt);

regards

Re: Pass parameters when loading script for QVW

Wed, 20 Aug 2014 15:01:54 GMT

can you send me an example.

I want to be able to pass params into the following where statement where the two dates are on a reload:

DIMFinancialPeriod:

SELECT date as FinancialPeriod

--date as SLRFinancialPeriod

, [Year] as 'Year'

, [quarter] as 'Quarter'

, left([month],3) as 'Month'

,left([month],3) + ' ' +[Year] as 'MonthYear'

,[Year] + ' ' + left([month],3) as 'YearMonth'

FROM Dates;

where date between '2013-04-01' and '2013-04-09';

Re: Pass parameters when loading script for QVW

Wed, 20 Aug 2014 15:04:58 GMT

Hi,

If you are using Desktop version, you can also pass parameters through command line like this

"D:\CLICKVIEW\QlikView\Qv.exe" /l /v var1= %DBNAME D:\qlickview\Copy of rpt_datafile1.qvw

Please refer this link below

Command line arguments in qlickview

Regs

-Ram

Re: Pass parameters when loading script for QVW

Wed, 20 Aug 2014 15:08:28 GMT

thanks but do you have an example based on what i sent

Re: Pass parameters when loading script for QVW

martynlloyd — Wed, 20 Aug 2014 15:12:14 GMT

Create a qvs file with params: you can use notepad or create a blank script and export.

Set vStartDate='2013-04-01';
Set vEnddate='2013-04-09'

Then use include to use it in your script

// Script
$(Include=community.qvs);

...
Where date between $(vStartDate) and $(vEndDate);

regards,

Re: Pass parameters when loading script for QVW

Thu, 21 Aug 2014 08:05:16 GMT

Can you give me an example of this please.

Re: Pass parameters when loading script for QVW

tresB — Thu, 21 Aug 2014 08:14:14 GMT

See, if this helps: Re: Load data based on a selection

Re: Pass parameters when loading script for QVW

Thu, 21 Aug 2014 08:29:26 GMT

DIMFinancialPeriod:

SELECT date as FinancialPeriod

--date as SLRFinancialPeriod

, [Year] as 'Year'

, [quarter] as 'Quarter'

, left([month],3) as 'Month'

,left([month],3) + ' ' +[Year] as 'MonthYear'

,[Year] + ' ' + left([month],3) as 'YearMonth'

FROM Dates

where date between '2012-04-01' and '2013-08-09';

So in the example above i want to pass param into the two dates on reload if that makes sense.

Re: Pass parameters when loading script for QVW

tresB — Thu, 21 Aug 2014 08:34:43 GMT

You mean passing variable like:

where date between '$(vDate1)' and '$(vDate1)'; ?

vDate1,vDate2 are variables defined somewhere prior to this statement.

Re: Pass parameters when loading script for QVW

Thu, 21 Aug 2014 10:00:56 GMT

so is it as simple as setting up the two variables and then the where statement? the date that will be passed into the variable will be entered by the admin user so I will use an object for that.

Re: Pass parameters when loading script for QVW

tresB — Thu, 21 Aug 2014 10:54:44 GMT

Yes. If you are thinking of allowing fron-end users control reload, that would not be an good idea and not an easy way to follow as well. For that you have to take the root of EDX. There are several discussions on the same here in community.

Re: Pass parameters when loading script for QVW

Thu, 21 Aug 2014 10:58:04 GMT

well it would only be for the single admin person.

Re: Pass parameters when loading script for QVW

Thu, 21 Aug 2014 14:03:42 GMT

can i send you the qvw if you could help at all please