Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculated dimension of time ranges on x-axis

I have a table like shown below

Time DurationId's
00:45A
00:35A
01:10B
01:16B

I wanted to plot a graph with Time Duration on X-axis and Count(Id's) on Y-axis (as expression). But on X-axis i wanted time duration as time range, i.e. 0 < x < 1 and 1 < x < 2 (count of id's with time duration between 0 and 1 hour; and 1 and 2 hours).

I used class function to group time duration like, Class([Time Duration], Time#(1,'HH')). It worked, but the problem is with the visualization. The X-axis scale is showing like 0 < x < 0.0034 and 0.004 < x < 0.0063 (some decimal number, i just wanted to indicate the how it is being show). How to make Class function understand that it is time that i am trying to display.

13 Replies
MarcoWedel

with some more Buckets:

QlikCommunity_Thread_134062_Pic3.JPG.jpg

QlikCommunity_Thread_134062_Pic2.JPG.jpg

hope this helps

regards

Marco

Not applicable
Author

Hi Marco

Your latest solution works like charm. Thanks!

-Sandeep

MarcoWedel

you're welcome

regards

Marco

Drewster
Contributor
Contributor

how can i open this?