Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
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

Tags (3)
1 Solution

Accepted Solutions
Employee
Employee

Re: XLS time format - messed up in QlikView

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
Employee
Employee

Re: XLS time format - messed up in QlikView

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

Not applicable

Re: XLS time format - messed up in QlikView

Thanks. It worked.

Re: XLS time format - messed up in QlikView

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