Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

time series functions, scale timestamp, line chart

Hello,

is there a possibility to visualize a great dataset with daily meaurements (1440 Measurements per day)?

I try qlikview, but it crashes often. There was an option to format the x-axes continous and I get a line chart with the hole dataset.

In Qlik Sense I don't found this option. I try some SQL commands like trunc(timestamp,'HH24'), but there are not supported.

The aggr() function isn't the solution.(picture 2) I need hourly measurements for every day, not the average over all days.

I read this post https://community.qlik.com/message/295553#295553

Is the only possibility a master calender?

Is there a possibility to scale the x axis with timestamp values? See picture 1.

4 Replies
MVP
MVP

Re: time series functions, scale timestamp, line chart

You can just add fields in the load script for date and hour:

LOAD

     TimestampField,

     Date(floor( TimestampField )) as Date,

     Hour( TimestampField )  as Hour,

     Timestamp( Round( TimestampField, 1/24)) as TimestampRoundedToHour,

     ...

FROM ...;

Then use these fields in your chart's dimension as needed.

MVP
MVP

Re: time series functions, scale timestamp, line chart

What if you truncate to hours in QlikView?

=TimeStamp(Round(TimeStamp, 1/24))

Not applicable

Re: time series functions, scale timestamp, line chart

I use a direct query connected to an oracle XE database.

When I put this fields into the load script, i got an error. No direct statement.

I tried the Native('') Command without success

Not applicable

Re: time series functions, scale timestamp, line chart

It doesn't work. Connection to database failed. I use a direct query in Qlik Sense.

Then I create a new dimension with your command.