topic Re: expression changes to integer value in QlikView

expression changes to integer value

surajap123 — Mon, 12 May 2014 13:51:15 GMT

Hi All,

Every time i reload the dashboard the variable(vMaxDate) containing expression =max(Date) is changing to integer number(41771), instead of Date value like 12/05/2014. This i can see in the input box.

I changed the expression from =max(Date) to =Date(max(Date)), but still the expession changes to integer number after reload.

Re: expression changes to integer value

anbu1984 — Mon, 12 May 2014 13:56:37 GMT

Try this

Date(max(Date),'M/D/YYYY')

Re: expression changes to integer value

surajap123 — Mon, 12 May 2014 14:02:48 GMT

Hi Ambu,

I tired with your expression, but still the expression is changed to integer value 41771(ie todays date), after the reload

Re: expression changes to integer value

ashfaq_haseeb — Mon, 12 May 2014 14:06:42 GMT

Hi,

can you post a sample app.

May be you have different date format.

Date(max(Date),'M/D/YYYY')

Replace 'M/D/YYYY' with your date format.

Regards

ASHFAQ

Re: expression changes to integer value

anbu1984 — Mon, 12 May 2014 14:12:46 GMT

Can you show your app?

Re: expression changes to integer value

surajap123 — Mon, 12 May 2014 14:18:03 GMT

Hi Ambu/Ashfaq,

I have checked the source table now, and i see that the date field value is 2014-05-12 09:51:40.807.

There is another date field in the dashboard for which the variable is working. This date field value is like 2009-03-07 00:00:00.000

So, having time stamp value like this (2014-05-12 09:51:40.807) is a problem?

How can i handle this?

Re: expression changes to integer value

Anonymous — Mon, 12 May 2014 14:24:46 GMT

To cut off the time part, you can use floor() function:

date(max(floor(Date)))

Re: expression changes to integer value

surajap123 — Mon, 12 May 2014 14:56:31 GMT

Hi Ambu / Ashfaq,

Please find the app and the source data.

Re: Re: expression changes to integer value

PrashantSangle — Mon, 12 May 2014 15:10:23 GMT

Hi,

Check Enclosed File.

It is as per your requirements.

Regards

Re: expression changes to integer value

surajap123 — Mon, 12 May 2014 15:16:47 GMT

Hi Michael,

Thanks for your reply !!

I have tried with the expression you provided. But still the expression changes to integer value for the vECBMaxDate variable.

Please find the app and source date i have attached in my earlier message. Kindly help !!

Re: expression changes to integer value

surajap123 — Mon, 12 May 2014 15:20:52 GMT

Hi Max,

Thanks !!

When i run the reload, the expression still changes to integer value for the variable vECBMaxDate..

Re: expression changes to integer value

Anonymous — Mon, 12 May 2014 15:21:28 GMT

It works this way because this variable is defined in the script, hence you get it after each reload. Yes, it is defined as a number:

Let vECBMaxDate = Num(Peek('maxDate', 0, 'Temp'));

Re: expression changes to integer value

Greg_Williams — Mon, 12 May 2014 15:29:14 GMT

Have you tried floor("date field") to strip the time?

Perhaps =date(date#("date field"),'MM-DD-YYYY')?

Verify the format for the field is not set to Integer in your chart properties > Number tab.

-Greg

Re: Re: expression changes to integer value

PrashantSangle — Mon, 12 May 2014 15:31:42 GMT

Hi,

Now checked Enclosed File.

Even after reloading the format is not changing.

Regards,

Re: expression changes to integer value

Anonymous — Mon, 12 May 2014 15:32:20 GMT

That is, if you remove this line in the script, you can define it in the Variables overview any way you want, and it will not be overwritten anymore.

Re: expression changes to integer value

surajap123 — Mon, 12 May 2014 15:33:35 GMT

Hi Michael,

I am not sure where to use your expression in the app.

The issue is, the variable vECBMaxDate is used in my charts and, whenever i reload, all my charts using the variable shows zero as values.

Please have a look at the app and souce data, i have attached in the previous message.

Re: Re: expression changes to integer value

Anonymous — Mon, 12 May 2014 15:36:51 GMT

There is nothing to use in the app - just remove or comment line 14 on the tab Calendar in the script.

Re: Re: Re: expression changes to integer value

Anonymous — Mon, 12 May 2014 15:43:35 GMT

Correction: You can not remove it because it is used further in the script. But you can change it - replace num with date:

Let vECBMaxDate = date(Peek('maxDate', 0, 'Temp'));

If you need it as num() in the script, use num($(vECBMaxDate)

See attached

Re: expression changes to integer value

surajap123 — Mon, 12 May 2014 16:02:05 GMT

Thanks everyone for your time..