Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
vibhu22oct
Contributor II
Contributor II

Negative Vertical Bar for Time Dimension

is it possible to show delta (difference) as negative vertical bar below x axis in case of time dimension

example time1 = 90 minutes, time2= 35 minutes, delta is 35-90=-55 minutes

 

like below shown for - 55 minutes

 

vibhu22oct_0-1714623129114.png

 

 

 

Labels (1)
3 Replies
Lisa_P
Employee
Employee

This should be fine

 

vibhu22oct
Contributor II
Contributor II
Author

sorry , it should be like below , time is in hh:mm format

time1= 04:00 and time2 =01:30 , difference = - 02:30

 

vibhu22oct_0-1714635043931.png

 

Chanty4u
MVP
MVP

Try this 

DeltaMinutes = Interval(time2 - time1, 'hh:mm') * 60