topic Use calendar to set a variable in QlikView

Use calendar to set a variable

Tue, 20 Mar 2012 22:37:14 GMT

Hi all,

I'd like a user to select a date from a calendar object, and then assign that value to a variable, eg. vDate.

Also, this date field will be an inputfield, so there won't necessarily be one assigned to the date field in the database.

Once the user has input/selected this date along with other values on a tablebox(which can be input/changed), I'd like to store it to a QVD.

Any idea?

Thanks!

Use calendar to set a variable

sivarajs — Wed, 21 Mar 2012 05:32:15 GMT

Hi,

Select Calendar object and goto properties--> select field --->selcet variable u created(like VDate)

Goto edit script,then define like

Tmp:

Load '$(VDate)' as datefeild autogenerate(1);

store Tmp into Tmp.qvd;

Hope this helps.......

Regards,

Sivaraj S

Re: Use calendar to set a variable

Wed, 21 Mar 2012 15:32:12 GMT

I am progressing a bit, and my records seem to be saving to my .xls doc., BUT

they don't seem to be returning what is contained in the excel file as :

Name	Grade	StartDate	EndDate
fdfds	Registrar	24/01/2012	25/01/2012
joe schmo	Registrar	05/03/2012	06/03/2012

Instead, my QV Chart is returning (just look at the 2 records for now):

1	fdfds	Registrar	05/03//2012	06/03//2012
2	joe schmo	Registrar	05/03//2012	06/03//2012
3			05/03//2012	06/03//2012
4			05/03//2012	06/03//2012
5			05/03//2012	06/03//2012
6			05/03//2012	06/03//2012
7			05/03//2012	06/03//2012
8			05/03//2012	06/03//2012
9			05/03//2012	06/03//2012
10			05/03//2012	06/03//2012

I think it's the way I'm joining the tables in the script .

Any help would be much appreciated ------- I think I've been looking at the scruipt for too long and my eyes are going out of focus.

Thanks!

Use calendar to set a variable

sivarajs — Thu, 22 Mar 2012 05:33:13 GMT

i think in script u are using autogenerate(10)

This will store 10 times the variable value,make that as 1

Sivaraj S

Re: Use calendar to set a variable

Thu, 22 Mar 2012 12:07:44 GMT

How could I go about changing this script slightly- probably using the iterno() function, so that it adds just 1 line under the current record, instead of a fixed amount eg.. autogenerate(10) or autogenerate(1).

So if I have 3 records, I like to add an extra row. ie. 3 and the 1 empty one.

My current script is:

Tmp:

Load
RecNo() as RecID,
'$(vStartDate)' as StartDate,
'$(vEndDate)' as EndDate autogenerate(10);

Any suggestions?

Use calendar to set a variable

sivarajs — Mon, 26 Mar 2012 04:40:57 GMT

Hi Bean,

Sorry, Can u explain the problem Clearly

Sivaraj S

Re: Use calendar to set a variable

Tue, 27 Mar 2012 07:50:10 GMT

I basically just want to be able to add an empty row or 1 extra row under the current 1.

I guess it needs a loop, instead of having a specific number of rows eg. autogenerate(10).

Use calendar to set a variable

sivarajs — Tue, 27 Mar 2012 08:58:00 GMT

Hi,

I dont think we can add a empty row

But we can add a column in script itself or while loading qvd

Sivaraj S

Re: Use calendar to set a variable

Tue, 27 Mar 2012 09:12:58 GMT

Is it possible to add a row using a macro?