topic Re: Time format Assigning to Slider Object in QlikView

Time format Assigning to Slider Object

kakani87 — Wed, 03 Jan 2018 14:08:57 GMT

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

Re: Time format Assigning to Slider Object

sunny_talwar — Wed, 03 Jan 2018 14:23:34 GMT

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

Re: Time format Assigning to Slider Object

Anonymous — Wed, 03 Jan 2018 15:32:26 GMT

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.

Re: Time format Assigning to Slider Object

kakani87 — Thu, 04 Jan 2018 05:23:16 GMT

Hi Sunny ..... PFA.

Re: Time format Assigning to Slider Object

kakani87 — Thu, 04 Jan 2018 06:38:41 GMT

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

Re: Time format Assigning to Slider Object

sunny_talwar — Thu, 04 Jan 2018 09:52:50 GMT

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

Re: Time format Assigning to Slider Object

kakani87 — Thu, 04 Jan 2018 11:21:26 GMT

Sunny Now this is corrected

Re: Time format Assigning to Slider Object

sunny_talwar — Thu, 04 Jan 2018 12:07:16 GMT

Check the attached..

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

Re: Time format Assigning to Slider Object

kakani87 — Fri, 05 Jan 2018 04:30:00 GMT

Thank you Sunny

Re: Time format Assigning to Slider Object

kakani87 — Fri, 05 Jan 2018 09:44:31 GMT

Hi Sunny when i'm considering this

instead of Min(signIn) and Max(Signout)

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

=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

Re: Time format Assigning to Slider Object

sunny_talwar — Fri, 05 Jan 2018 09:46:44 GMT

Set analysis syntax is not right... try this

=Min({<tran_date = {"$(=Date(Max(tran_date)))"}>}SignIn)

Re: Time format Assigning to Slider Object

kakani87 — Fri, 05 Jan 2018 12:23:14 GMT

Sunny When the same set expression added into my chart then it is behaving like this with no data

Re: Time format Assigning to Slider Object

sunny_talwar — Fri, 05 Jan 2018 12:39:50 GMT

Not sure what you are trying to get, but may be one of the two

1) =Min({<tran_date = {"$(=Date(Max(tran_date)))"}>}SignIn)

2) =FirstSortedValue(Aggr(Min(SignIn), EmpName, tran_date), -Aggr(tran_date, EmpName, tran_date))

Re: Time format Assigning to Slider Object

kakani87 — Fri, 05 Jan 2018 13:06:37 GMT

I'm trying to display as per the requirement Min SignIN and Max SignOut for monitoring the emp In and Out timings

=FirstSortedValue(Aggr(Min(SignIn), EmpName, tran_date), -Aggr(tran_date, EmpName, tran_date))

This is displaying the values properly but what my question is can we display as on date values like you suggested me with a set expression in the above one because that set expression returns no data as shared you the screen earlier.

Apart from this first sorted value returns the min value is there any thing for max value like last signout

Re: Time format Assigning to Slider Object

sunny_talwar — Fri, 05 Jan 2018 13:09:43 GMT

Share the application as I have no idea why it isn't working for you, when it is working for me

Re: Time format Assigning to Slider Object

kakani87 — Fri, 05 Jan 2018 13:41:05 GMT

Sunny PFA.

Re: Time format Assigning to Slider Object

sunny_talwar — Fri, 05 Jan 2018 13:47:29 GMT

I open your dashboard and see this

What am I missing? I don't see any nulls?

Re: Time format Assigning to Slider Object

kakani87 — Fri, 05 Jan 2018 13:53:13 GMT

All this is with the help of you but can we display only max date i.e jan 1st data only apart from all days data

Re: Time format Assigning to Slider Object

sunny_talwar — Fri, 05 Jan 2018 13:59:08 GMT

I understand the problem now... you tran_date is actually in number format, you only gave it a date format with the chart properties... Set analysis is very sensitive to formats, so when we used this

=Min({<tran_date = {"$(=Date(Max(tran_date)))"}>} SignIn)

The comparison was done from Num to Date... which won't work... but this will

=Min({<tran_date = {"$(=Num(Max(tran_date)))"}>} SignIn)

Re: Time format Assigning to Slider Object

kakani87 — Fri, 05 Jan 2018 14:11:41 GMT

Thank you very much Sunny