topic Re: Assign Time to slider Object in 10 Mins Difference in QlikView

Assign Time to slider Object in 10 Mins Difference

kakani87 — Thu, 18 Jan 2018 13:20:02 GMT

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

(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.

sunny_talwar — Thu, 18 Jan 2018 13:22:53 GMT

Check attached

kakani87 — Thu, 18 Jan 2018 13:35:00 GMT

If we slide the object Data is not displaying accordingly Sunny

sunny_talwar — Thu, 18 Jan 2018 13:43:28 GMT

check now

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

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