Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
What if you truncate to hours in QlikView?
=TimeStamp(Round(TimeStamp, 1/24))
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
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.