topic count based on a time range in QlikView

count based on a time range

anjali0108 — Tue, 05 Jan 2016 09:09:34 GMT

Hi,

I have to show some tickets count for yesterday that were logged from 8 am to 8 pm .

Can anybody suggest what expression should i use restrict time as such and display the same ?

Re: count based on a time range

sunny_talwar — Tue, 05 Jan 2016 14:47:21 GMT

May be this:

{<DateTimeField = {"$(='>=' & TimeStamp(DayStart(Today()) + 8/24) & '<=' &TimeStamp(DayStart(Today()) + 20/24))"}>}

Where DateTimeField is the same format as TimeStamp(DayStart(Today()) + 8/24)

Re: count based on a time range

anjali0108 — Fri, 22 Jan 2016 09:24:03 GMT

Hi Sunny ,

Thanks for the help .

I have one more question .

If someone selects some dates and want the data to change accordingly and wants this 8 am to 8 pm time frame as default if he selects nothing ,then, Is there any way I can do so ?

Any help will be appreciated .Thanks

Re: count based on a time range

sunny_talwar — Fri, 22 Jan 2016 11:15:42 GMT

I think it's doable. Change Today() to a variable which is driven by user input from a input box may be