Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joeybird
Contributor II

group by 15 minute intivals, but show negative times in 15 minutes


Hi

I have this as a measure

count OrderID

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

Kind Regards

7 Replies

Re: group by 15 minute intivals, but show negative times in 15 minutes

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.

Re: group by 15 minute intivals, but show negative times in 15 minutes

Have you tried to create this in the script to see if it ever gets a negative value?

time(round( frac([OrderTimeMinutes]) + (7/1440), 1/24/4) , 'hh:mm')

joeybird
Contributor II

Re: group by 15 minute intivals, but show negative times in 15 minutes

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

-28

-1

0

2

3

20

58

please help

Re: group by 15 minute intivals, but show negative times in 15 minutes

I guess time cannot be negative... try with Interval instead of time

Interval(round( frac([OrderTimeMinutes]) + (7/1440), 1/24/4) , 'hh:mm')

joeybird
Contributor II

Re: group by 15 minute intivals, but show negative times in 15 minutes

Hi

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

OrderTimeMinutes

going into buckets of 15 (just have to label as minutes )... hence I may be able to get negative values

e.g

-30

-15

0

15

30

45

please help

joeybird
Contributor II

Re: group by 15 minute intivals, but show negative times in 15 minutes

Hi

I am happy to go with + time, and get uses to sort out the time field to stop negative values

however

I have the

OrderTimeMinutes

how do I change below to use the OrderTimeSeconds  field please?

Interval(round( frac([OrderTimeMinutes]) + (7/1440), 1/24/4) , 'hh:mm')

so e.g

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

Kind Regards

Re: group by 15 minute intivals, but show negative times in 15 minutes

No idea what you mean....

Community Browser