topic Re: XLS time format - messed up in QlikView in QlikView

XLS time format - messed up in QlikView

Thu, 10 Jul 2014 19:26:24 GMT

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

Re: XLS time format - messed up in QlikView

Clever_Anjos — Thu, 10 Jul 2014 19:31:00 GMT

Check if this fix your issue

LOAD time(Time) as Time,

text(Network) as Network,

Server,

Browser,

Total

FROM

(ooxml, embedded labels);

Re: XLS time format - messed up in QlikView

Thu, 10 Jul 2014 19:46:07 GMT

Thanks. It worked.

Re: XLS time format - messed up in QlikView

its_anandrjs — Thu, 10 Jul 2014 19:47:12 GMT

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