topic Defining Variables in QlikView

Defining Variables

Wed, 23 Feb 2011 21:35:23 GMT

I am still new to Qikview - I am looking at an example from this forum

4 variables are defined in the script but on the objects there are 4 more variables available

vStartdate, VEndDate are 2 of them

They seem to derive their values from a calendar input object , as i change the dte in the calendar object the value of the variable changes

- but how do I define the variable??

i.e.vStartDate = entered date in calendar object

where in Qlikview doI define these variables and where do i find their definitions - i caan only see the value not how it is derived

sorry - this is probably a really simple question but i am stumped

thanks

Defining Variables

Wed, 23 Feb 2011 21:41:29 GMT

Hello,

You can see the definition under Settings menu --> Variable Overview option.

Regards,

Defining Variables

Wed, 23 Feb 2011 21:47:55 GMT

Thanks so much for the quick reply - my problem is i can't?

in the variable overview box it lists the variables in variables but when i click on one - it just shows me 39542

if i pick a new date in the calendar object - this value changes - but I can't seem to access how the value is calculated

Defining Variables

Wed, 23 Feb 2011 21:53:59 GMT

I downloaded the file from this post

The Basics about Dates, Date Ranges and Set Analysis

posted by Miguel Angel Baeyens

11-05-2010

Defining Variables

johnw — Wed, 23 Feb 2011 22:06:38 GMT

I'm not sure what you mean by "how it is derived". The calendar input object is almost certainly the way these variables are entered.

You can see variable definitions here:

Settings -> Document Properties -> Variables

Internally, dates are stored as the number of days since December 30, 1899. The date you're looking at is 39542 days since December 30, 1899, which is April 4, 2008. Not sure why the variable overviews aren't smart enough to format it. I suppose because there appears to be no direct way to tell QlikView that it's a date, but only ways to tell it "I want to enter this number using a calendar object". Functionally it's a date then, but parts of QlikView apparently remain unaware that that's how you're using it.

Defining Variables

Wed, 23 Feb 2011 22:10:43 GMT

What kind of object is your Calendar object?

It's possible that the variable could be being created from a macro. Can you upload your example for review that?

Defining Variables

Wed, 23 Feb 2011 22:13:41 GMT

Thanks so much for the quick reply - I downloaded the file in the previous post

The Basics about Dates, Date Ranges and Set Analysis

The calendar object SL01 Start date - under Properties / General / Data uses the variable VStartDate from a drop down list - If you look at the list

vMinDate,vMaxdate,vYearMax and vYearMin are defined in the script

but where are vStartDate, vEndDate, vYear1 and vYear2 defined? they appear in the drop down list?

am I being really stupid?

Defining Variables

Wed, 23 Feb 2011 22:14:28 GMT

The Basics about Dates, Date Ranges and Set Analysis

I downloaded the file from here on the forum

Defining Variables

johnw — Wed, 23 Feb 2011 22:20:01 GMT


ajlwhite wrote:where are vStartDate, vEndDate, vYear1 and vYear2 defined?

Settings -> Document Properties -> Variables

Defining Variables

Wed, 23 Feb 2011 22:35:27 GMT

I am being dumb - I have it now - thanks for your patience

it seems simple - you just define a variable and let the slider object populate