Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have this as a measure
This as a dimension
time(round( frac([OrderTimeMinutes]) + (7/1440), 1/24/4) , 'hh:mm')
this shows on the
but only showing positive time x axis in 15 minute intivals as
00:00, 00:15, 00:30 as I want
but some dates have been entered wrong in the system
thus I should have time buckets of
-00:15 , -00:30
How do I get those to appear please
Hard to say without knowing what kind of entered wrong in the system
Maybe share some sample data and a sample qvf that demonstrates your issue.
Have you tried to create this in the script to see if it ever gets a negative value?
if I put it as a measure
I do get the buckets
of 00:00, 00:15, 00:30 ect
but it does not work in the load...
I get 00:00 for all values
the format of OrderTimeMinutes looks like
I guess time cannot be negative... try with Interval instead of time
Interval(round( frac([OrderTimeMinutes]) + (7/1440), 1/24/4) , 'hh:mm')
the same happens in the data load and a measure
all appear as 00:00
I would prefer time, but it looks like cannot produce a negative time
is there a way of making
going into buckets of 15 (just have to label as minutes )... hence I may be able to get negative values
I am happy to go with + time, and get uses to sort out the time field to stop negative values
I have the
how do I change below to use the OrderTimeSeconds field please?
600 seconds would be in the 00:00
755 seconds would be in the 00:00
900 seconds would be in the 15:00 ect
No idea what you mean....