Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
desmond_mf_fung
Contributor
Contributor

Data cannot load by Auto-Calendar

I have a column call logon time, the data format is as below.
 

Logon Time
24/07/2015 01:12
24/07/2015 01:17
24/07/2015 01:17
24/07/2015 01:26
24/07/2015 01:26
24/07/2015 01:35

Thus, I set the load description below in data load editor.

SET TimestampFormat='DD/MM/YYYY  hh:mm';


Then, it generates the year/month by the auto calendar script.
However, no data is available when I try to drop a selection box. I think no data can be transform. 

2018-05-15_15-53-42.jpg

Please help.

Desmond

0 Replies