topic Re: Data Restriction On Time & Date in QlikView

Data Restriction On Time & Date

Anonymous — Mon, 16 Feb 2015 16:11:18 GMT

Hi,

I have a scenario where data consists of Date & Time. Now If User wants to see report then it should show values from Yesterday 6.00AM to Today 6.00 AM.Please look into it.

Thanks in Advance

Re: Data Restriction On Time & Date

alexandros17 — Mon, 16 Feb 2015 16:15:44 GMT

When you open the document use the trigger OnOpen (settings -> document properties -> triggers -> onopen -> add -> select in field then write your date time field name and in the lower box write the condition

Re: Data Restriction On Time & Date

Anonymous — Mon, 16 Feb 2015 17:05:04 GMT

Thanx Alessandro.......Could you please elaborate it more....

Re: Data Restriction On Time & Date

Mon, 16 Feb 2015 17:21:33 GMT

Hi Himanshu,

What Alexandro meant was goto Document Properties >> refer screenshot below and add the value in search string.

Re: Data Restriction On Time & Date

Anonymous — Mon, 16 Feb 2015 17:45:01 GMT

Hi Krishna,

I appreciate your effort....But seriously I am not getting how to show data from yesterday 6.00AM to Today 6.00AM

Re: Data Restriction On Time & Date

Mon, 16 Feb 2015 17:47:25 GMT

Can you post sample .qvw with relevant data so that I can help you on this issue.

Re: Data Restriction On Time & Date

Anonymous — Mon, 16 Feb 2015 17:57:15 GMT

In the screenshot from HareKrishna enter the search string:

= '>=' & timestamp(today()-1/4) & '<=' & timestamp(today()+3/4)

Edit: The example above is 6 PM to 6 PM. For AM:

= '>=' & timestamp(today()-3/4) & '<=' & timestamp(today()+1/4)

Re: Data Restriction On Time & Date

Anonymous — Mon, 16 Feb 2015 17:57:49 GMT

Here I have attached sample data...Now suppose today 16Feb'15....In dashboard it should show data from 15Feb 6.00 AM to 16Feb 6.00AM .....In this manner...Did You get my point????

Re: Data Restriction On Time & Date

maxgro — Mon, 16 Feb 2015 19:21:27 GMT

PFA

test:

Load

Date + Time as DateTime;

LOAD userId,

Date,

Time

FROM Test.xls

(biff, embedded labels, table is Sheet1$);

search string on field DateTime

= '>=' & (today()-14-1/4) & '<=' & (today()-14+3/4)

when you have record for today and yesterday in your excel, remove -14

Re: Data Restriction On Time & Date

Anonymous — Tue, 17 Feb 2015 06:45:27 GMT

Hi Massimo,

Thanks a Lot......I got correct answer...Could you please explain the logic???

Re: Data Restriction On Time & Date

jagan — Tue, 17 Feb 2015 07:09:32 GMT

Hi,

Today() gives you 2/17/2015 12:00:00

1/4 = 6/24 = 6 AM (6 AM/24 Hrs)

We are adding Today() + 1/4 which gives 2/17/2015 06:00:00

3/4 = 18/24 = 6 PM (18/24 Hrs)

We are adding Today() + 3/4 which gives 2/17/2015 18:00:00 OR 06:00:00 PM

Hope this helps you.

Regards,

Jagan.

Re: Data Restriction On Time & Date

maxgro — Tue, 17 Feb 2015 09:40:26 GMT

1 is one day

1/4 is 1/4 of a day, --> 6 hours

1/24 is 1 hour

......