Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
kakani87
Specialist
Specialist

Assign Time to slider Object in 10 Mins Difference

Dear All,

Here i would like to assign time to a slider difference of 10 mins and considered a variable vBreak = [Break in Mins]

As 0 - 5 hrs

now this variable is used in the expression

if

(interval(Interval(sum([break in mins]),'hh:mm:ss'),'mm')>=interval(replace($(vBreak),'.',':')&':00','mm'),

interval(Interval(sum([break in mins]),'hh:mm:ss'),'hh:mm') )

in slider vBreak is assigned as variable and values as below

Min   Max    Static

0       5         0.10

but  this slider is displayed like   0  , 0.10 , 0.20 .....  0.90 , 1 , 1.10  ...  1.90 , 2


I need this to be displayed as 0, 0.10 , 0.20, .... 0.50, 1

for each hour 0-5 hrs.

1 Solution

Accepted Solutions
sunny_talwar

check now

if

(Interval(sum([break in mins]),'hh:mm:ss')>=$(vBreak),

interval(Interval(sum([break in mins]),'hh:mm:ss'),'hh:mm') )

View solution in original post

3 Replies
sunny_talwar

Check attached

Capture.PNG

kakani87
Specialist
Specialist
Author

If we slide the object Data is not displaying accordingly Sunny

sunny_talwar

check now

if

(Interval(sum([break in mins]),'hh:mm:ss')>=$(vBreak),

interval(Interval(sum([break in mins]),'hh:mm:ss'),'hh:mm') )