Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qliklizzy
Creator II
Creator II

Round up a time to nearest 15 mins and display as 1 hour 30 mins

Hi 

i have seached this site to come up with the below but i need extra help mixing them together - please?

i have this expression which gives me the display  i need:

=replace(replace(interval(max({<MetricDesc=,MetricID={'LI01'},
Location={'Minors','ADULT MIN'},
SeenByPractitioner={'No'},Status={'DOC/PRAC','REG','WAIT CUB'}>}
AETotalWait)/24/60,'h X - m Z'), 'X', 'hours'), 'Z', 'mins')

and i have this that gives me the round up I need:

=Time(interval#(ceil(num#(text(interval(max({<MetricDesc=,MetricID={'LI01'},
Location={'AM','MAJORS','ADULT AM','AMB/STAT'},
SeenByPractitioner={'No'},Status={'DOC/PRAC','REG','WAIT CUB'}>}
AETotalWait)/24/60, 'mm'))),15),'m'))

how do i combine them both so i get  a time stamp in the 1 hour 30 min display even if my time is 1 hour 25 so its rounded up. 

 

 

Labels (5)
1 Solution

Accepted Solutions
qliklizzy
Creator II
Creator II
Author

ive done it!! :):):)

 

=replace(replace(interval(Time(interval#(ceil(num#(text(interval(max({<MetricDesc=,MetricID={'LI01'},
Location={'Minors','ADULT MIN'},
SeenByPractitioner={'No'},Status={'DOC/PRAC','REG','WAIT CUB'}>}
AETotalWait)/24/60, 'mm'))),15),'m')) ,'h X - m Z'), 'X', 'hours'), 'Z', 'mins')

View solution in original post

1 Reply
qliklizzy
Creator II
Creator II
Author

ive done it!! :):):)

 

=replace(replace(interval(Time(interval#(ceil(num#(text(interval(max({<MetricDesc=,MetricID={'LI01'},
Location={'Minors','ADULT MIN'},
SeenByPractitioner={'No'},Status={'DOC/PRAC','REG','WAIT CUB'}>}
AETotalWait)/24/60, 'mm'))),15),'m')) ,'h X - m Z'), 'X', 'hours'), 'Z', 'mins')

View solution in original post