Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
megan_deboer
Partner - Contributor II
Partner - Contributor II

Bar Chart Timestamp as Dimension

Hi:

I am using an excel spreadsheet to load my data and have the employee activity with the timestamp. Is there a way to display the timestamp within a drill down? I'm not able to determine how to display the time in the field. When I'm loading the data in the data manager it is identifying it as a timestamp.  Would like to show the activity by day plotted by time within the bar graph. 

I appreciate the help! 

Megan

3 Replies
Lisa_P
Employee
Employee

You can create a Master Dimension to drill down from Date to Time if this is what you are trying to do.
megan_deboer
Partner - Contributor II
Partner - Contributor II
Author

Hi Lisa:

Yes, that sounds great. Currently, my dimension options for the date is the original field and the auto calendar. Any idea what I would put for the time stamp to display?

Thank you! Megan

Lisa_P
Employee
Employee

You can reset your date field to have no time factor as the first dimension in your drill down:

Floor(date)

And then derive the timestamp from the original date for the second dimension

Timestamp(date, 'hh:mm')