topic Re: Hour like filter in QlikView

Hour like filter

Tue, 14 Jun 2016 20:09:15 GMT

Hi everyone!

I need to use the date field as a filter, to choose a time within 24 hours that exists in a day, but when I put it in a box simple table when I print all rows.

What can I do ??

thks.

Re: Hour like filter

sunny_talwar — Tue, 14 Jun 2016 20:34:03 GMT

but when I put it in a box simple table when I print all rows.

I don't understand this? Would you be able to elaborate?

Re: Hour like filter

Tue, 14 Jun 2016 20:40:19 GMT

sorry man, the translator...

when I put the time in a list box this is repeated for each row there

Re: Hour like filter

sunny_talwar — Tue, 14 Jun 2016 20:52:48 GMT

Well, I guess each day has all the 24 hours so wouldn't you see the 24 hours for each day? Do you want to hide the list box for time when date is not selected?

Re: Hour like filter

Tue, 14 Jun 2016 21:03:04 GMT

I want you to show me a single value for each hour for use as a filter as are the filter day, month and year.

Re: Hour like filter

sunny_talwar — Tue, 14 Jun 2016 22:42:55 GMT

May be create a field in the script like this:

Time(Hour(TimeStamp), 'hh TT') as Hora

Time(Floor(Frac(TimeStampField), 1/24), 'hh TT') as Hora

Re: Hour like filter

swuehl — Tue, 14 Jun 2016 22:55:21 GMT

Seems like you have formatted the value as 'hh TT', but keeping the underlying numeric value including minutes, seconds etc.

try either

Hour(TIMESTAMPFIELD) as HORA

to create a 24h based values or

Time#(Time(TIMESTAMPFIELD,'hh TT'),'hh TT') as HORA

which should re-interpret the value from the formatted output and set the numeric representation accordingly.

Re: Hour like filter

Tue, 14 Jun 2016 22:59:30 GMT

I found the answer!

Correct Time Arithmetic | Qlikview Cookbook

Re: Hour like filter

swuehl — Wed, 15 Jun 2016 08:25:14 GMT

Great!

How does your final statement look like?

If your request is resolved, then please close this thread.

Qlik Community Tip: Marking Replies as Correct or Helpful