Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
surajap123
Creator II
Creator II

Date format gone

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.

8 Replies
Digvijay_Singh

Try this -

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

sunny_talwar

I think you mean this:

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

surajap123
Creator II
Creator II
Author

Sorry for not being clear.

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

sunny_talwar

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

miguelbraga
Partner - Specialist III
Partner - Specialist III

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

antoniotiman
Master III
Master III

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

surajap123
Creator II
Creator II
Author

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

Not applicable

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