Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-10-08 05:24 AM

Dates are showing incorrect


Hi,

I have a list box with Date. The values are showing fine upto 2013/09/28 but afterwards yit is showing 41564.44683923 and so on.

again after 41564.------  it is showing multiple times the below dates

2013/09/30, 2013/10/01

Could anyone let me know why it is happening.

Thanks.

2,019 Views
0 Likes
31 Replies
Not applicable
‎2013-10-09 06:52 AM
Author

In response to

Hi,

I used Left Join instead of Concatenats in Link table. It's showing only EnquiryID and all Staright/ Pivot tables and all list boxes are showing empty. Please help me as I am really confusing and I suppose I am doing entirely wrong in script. Please help.

127 Views
0 Likes
Arthur_Fong
Partner - Specialist III
Partner - Specialist III
‎2018-08-15 02:53 AM

Hi Amelia D,

Format your date correctly. For example, standardizing all dates to only use number formats.

The syntax of doing this is : num(Date(<DateField>)).

Next, you have to ensure that you have the correct key used in joining all the tables.

If the tables are joined correctly, you should not have null values in the front end.

Thanks and regards,

Arthur Fong

127 Views
0 Likes