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: 
Not applicable

XLS time format - messed up in QlikView

Have 5 columns in an XLS. First column is time in format 1:30 PM. Second Column is Network.

Issue:

Time in QV is messed up.

Second Column get the AM/PM

Please see the attachments if I could explain better.

Appreciate help.

thanks

Rajesh

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

Check if this fix your issue

LOAD time(Time) as Time,

     text(Network) as Network,

     Server,

     Browser,

     Total

FROM

(ooxml, embedded labels);

View solution in original post

3 Replies
Clever_Anjos
Employee
Employee

Check if this fix your issue

LOAD time(Time) as Time,

     text(Network) as Network,

     Server,

     Browser,

     Total

FROM

(ooxml, embedded labels);

Not applicable
Author

Thanks. It worked.

its_anandrjs

Try with this load scripts

LOAD

     Time(Time) as Time,

     Network as Network,

     Server,

     Browser,

     Total

FROM

SNOW_0709.xlsx

(ooxml, embedded labels, table is Sheet2);

I use your data from second sheet by copy and paste the data from sheet one and then use it from sheet 2 may be some formatting problem.

Hope this helps