topic Variable getting change??? in QlikView

Variable getting change???

Anonymous — Mon, 29 Oct 2012 06:17:39 GMT

Hi Experts,

This post quite been simple but getting trouble with this...

I have declared a variable in Document properties, like "=date(today())"

After some days or subsequent reload the value is getting changed to some date, I wanted the value to be constant as "=date(today())".

How could I resolve this???

Many thanks in Advance...

Re: Variable getting change???

Mon, 29 Oct 2012 06:59:56 GMT

Hi,

today() will itself return date in proper format, no need of date() function.

Regards

Re: Variable getting change???

sivarajs — Mon, 29 Oct 2012 07:14:39 GMT

Today will return Current date and time ,obviously it will get change for every reload

Re: Variable getting change???

Mon, 29 Oct 2012 07:15:13 GMT

Hi,

Variables can contain numeric or alphanumeric data. If the first character of a variable value is an equals sign ' = ' QlikView will try to evaluate the value as a formula (QlikView expression) and then display or return the result rather than the actual formula text.

That is why the value of your variable is date "10/09/2012" and not "=date(today())".

Regards,

Janzen

Re: Variable getting change???

Anonymous — Mon, 29 Oct 2012 07:34:57 GMT

thanks for the response..

then how could i proceed with today() after reload also...

Re: Variable getting change???

Mon, 29 Oct 2012 07:38:46 GMT

Hi,

What do you mean? After reload, the value of the variable must be today()? When do you trigger your reload?

Regards,

Janzen

Re: Variable getting change???

Mon, 29 Oct 2012 07:39:26 GMT

whichver date u want u can hardcode it in var, for eg, if u always want to show 29/10/2012,use

var=date(41211)

So, even after u relaod after few days it will remain 29/10/2012

to convert date to num,u can use: num(ur date)

Re: Variable getting change???

Anonymous — Mon, 29 Oct 2012 07:40:51 GMT

I am using that varible for my calender object so daily it should show the current date...

Re: Variable getting change???

Mon, 29 Oct 2012 07:41:45 GMT

then u can simply use today() as ur variable value

Re: Variable getting change???

jagan — Mon, 29 Oct 2012 08:16:41 GMT

Hi Madhu,

If you want to change the date variable based on the current date, then create a variable and assign

=Today()

as expression. This automatically returns you current date.

Hope this helps you.

Regards,

Jagan.

Re: Variable getting change???

Anonymous — Mon, 29 Oct 2012 10:38:36 GMT

Ya thanks yaar...

I am using that variable as calender object so whenever i change date in calender object automatically my variable =today() is changing to the some "10/09/2012" date...

If i open for 10-Oct-2012 that "=today()" changing to to "10/09/2012" date subsequently if i open for 11-Oct-2012 it should change the today() date 11th OCT right?? but it is not changing

Re: Variable getting change???

sivarajs — Mon, 29 Oct 2012 11:13:00 GMT

Today will take the system date

Whats your variable exactly want to do for you?

Re: Variable getting change???

Anonymous — Mon, 29 Oct 2012 11:45:59 GMT

daily when i open the application the date should change to current date i.e.today..(as mentioned in the screenshot) but it not automatically changing to current date that is the exact problem.. I wanted the date to be 29th OCT but stil in 5th OCT...

Since my variable is getting change it is adopt to that particular date(5th OCT) not as today()...

Re: Variable getting change???

sivarajs — Mon, 29 Oct 2012 12:01:10 GMT

I dont know how you are calling date field into calendar object but for me its coming

vToday=today()

Re: Variable getting change???

magavi_framsteg — Mon, 29 Oct 2012 12:04:44 GMT

Also, it makes a big difference if you declare your variable vToday with LET or SET.

If you declare it in your load script, you should use SET.

SET vToday = today();

Kind regards

Magnus Åvitsland

BI Architect Consultant

Framsteg Business Intelligence Corp.