topic Re: Date format gone in QlikView

Date format gone

surajap123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

When i do resident load and drop the main table, I notice that the charts are broken. When i dig into it, I see that the Date field format is gone, so the expressions doesnt work.
eg- sum({<Date = {<'$(=max(Date))'>}>}sales)

sum({<Date = {<'$(=max(41913))'>}>}sales).

The Date field in the modifier expects date in DD/MM/YYYY format, but the max function is returning date as number(when i do resident load). so expression is not working. However the date in listbox is visible as DD/MM/YYYY.

Please let me know the reason.

Re: Date format gone

Digvijay_Singh — Fri, 23 Sep 2016 09:03:53 GMT

Try this -

sum({<Date = {<'$(=max(Date(Date,'DD/MM/YYYY')))'>}>}sales)

Re: Date format gone

sunny_talwar — Fri, 23 Sep 2016 09:18:28 GMT

I think you mean this:

Sum({<Date = {"$(='<' & Date(Max(Date),'DD/MM/YYYY'))"}>}sales)

Re: Date format gone

surajap123 — Fri, 23 Sep 2016 09:26:12 GMT

Sorry for not being clear.

My question is, does resident load, remove the date format and covert to num.

Re: Date format gone

sunny_talwar — Fri, 23 Sep 2016 09:45:17 GMT

That should not happen. Can you share an instance where it is happening?

Re: Date format gone

miguelbraga — Fri, 23 Sep 2016 09:50:30 GMT

That behavior is very odd, mate. Can you please share with us your script where you call the Resident Load?

Best regards,

D.A. MB

Re: Date format gone

antoniotiman — Fri, 23 Sep 2016 10:04:13 GMT

Hi Suraj,

I think this is correct behaviour.

Date is Dual field (num,text)

Date(41913) -> 01/10/2014

Max(Date) -> 41913

MaxString(Date) -> 01/10/2014

Regards,

Antonio

Re: Date format gone

surajap123 — Fri, 23 Sep 2016 12:28:59 GMT

Thanks for all the inputs. I will properly test and get back. Thanks

Re: Date format gone

Tue, 18 Oct 2016 15:54:59 GMT

I also am having a similar issue. When I try to use the Date function (i.e. Date(DATE_FIELD) as DATE_FIELD) in a resident load the function does not work; however, the function works when I use the exact same syntax with a load from a QVD.

I've also tried Date(Floor(DATE_FIELD)) as DATE_FIELD and I have the same issues with a Resident Load. Any insight would be greatly appreciated!

Thanks,

Chas