Time format Assigning to Slider Object

[kakani87]

Dear All,

I'm having data like Date , Emp, IN and OUT timings

now I want to display Employees IN time >10:00:00 to highlight and this is shown but this should be assigned to a slider where user can make changes IN time from 9:30:00  to 10:30:00

Date | Emp | IN | OUT

with min signIN time and max signOut for max date using set expression.

Able to give 9,10 like numeric values in min and max slider values how to set the range in time interval

Shared a Sample Document.

I appreciate the Response for this post 

[sunny_talwar]

The document is empty... would you be able to reload with data and add the objects you have thus far

[Anonymous]

I think the attached is what your looking for, I had to create an inline table with Time at 10 minute intervals for the slider.

[kakani87]

Hi Sunny ..... PFA.

[kakani87]

Dear Gareth,

This is exactly what i want but not able to implement with my data so could you check my sample once.

Because there are multiple in and out entries available for each employee.

should consider Min_IN  as IN and Max_Out as Out as on date

here I'm sharing a sample

[sunny_talwar]

There seems to be an issue with your calendar within QlikView.... It isn't correctly connected to your data table... I think you should resolve this issue before you go on to address anything else.

The red highlighting comes from calendar and black one comes from your XsDetails_emp

Ideally, the numbers should be shown as dates and should correctly align with your fact table dates

[kakani87]

Sunny Now this is corrected

[sunny_talwar · Accepted solution]

Check the attached..

Changed your expression, expression's format and variable ranges and variable format

[kakani87]

Thank you Sunny

[kakani87]

Hi Sunny when i'm considering this

instead of Min(signIn) and Max(Signout)

=Min({<tran_date={'max(date(tran_date))'}>}SignIn)

or

=Min({<tran_date={'max(tran_date)'}>}SignIn)

AND

=Max({<tran_date={'max(date(tran_date))'}>}SignIn)

this is not displaying the maximun date details where i'm going wrong.

by default this has to be displayed max tran_date details