topic Re: dynamically creating time slots based on user preference in QlikView

dynamically creating time slots based on user preference

Wed, 21 Aug 2013 08:39:53 GMT

how to dynamically create the time slots based on user preference.

Eg:
15mins,30 min, 1hr,1day -> should be the possible values for selection.

Re: dynamically creating time slots based on user preference

sparur — Wed, 21 Aug 2013 08:50:49 GMT

as I understand you, you could use section Access for your task. where you can assigned correct values per specific user.

Re: dynamically creating time slots based on user preference

Wed, 21 Aug 2013 09:28:31 GMT

section acess? can you please me detail me about this?

Re: dynamically creating time slots based on user preference

sparur — Wed, 21 Aug 2013 09:31:03 GMT

you could find more details here:
http://community.qlik.com/docs/DOC-1853

Re: dynamically creating time slots based on user preference

Wed, 21 Aug 2013 09:39:42 GMT

actually i want it in calendar object. something like the below. depending on user input time slot should change

2013/07/26 4:15:00 AM

2013/07/26 4:00:00 AM

2013/07/26 4:30:00 AM

2013/07/26 3:45:00 AM

2013/07/26 4:00:00 AM

2013/07/26 4:40:00 AM

2013/07/26 4:20:00 AM
2013/07/26 3:40:00 AM

2013/07/26 4:00:00 AM

2013/07/26 4:30:00AM

2013/07/26 3:30:00 AM

Re: dynamically creating time slots based on user preference

sparur — Wed, 21 Aug 2013 09:47:54 GMT

yep, you could create a special Section Access table, where restrict data per user.

Re: dynamically creating time slots based on user preference

Wed, 21 Aug 2013 11:32:00 GMT

i want something like input box or list box for time slots(15 minutes, 30 minutes, 1 hour, 1 day).

According to selection, the calendar values should change.

Re: dynamically creating time slots based on user preference

sparur — Wed, 21 Aug 2013 11:37:08 GMT

Could you provide some examples?

if the user select 1 day in the input box, what should he see in the Date listbox?

if he select 1 hr,...

etc

Re: dynamically creating time slots based on user preference

Wed, 21 Aug 2013 11:40:47 GMT

like the below in list box

if 15 minute interval (user select 15 minute in input box)

2013/07/26 4:15:00 AM

2013/07/26 4:00:00 AM

2013/07/26 4:30:00 AM

2013/07/26 3:45:00 AM

if 20 minute inteval

2013/07/26 4:00:00 AM

2013/07/26 4:40:00 AM

2013/07/26 4:20:00 AM
2013/07/26 3:40:00 AM

if 30 minute interval

2013/07/26 4:00:00 AM

2013/07/26 4:30:00AM

2013/07/26 3:30:00 AM

Re: dynamically creating time slots based on user preference

sparur — Wed, 21 Aug 2013 12:47:03 GMT

I think you could create additional table for Calendar, which assign your intervals and dates. For example:

Interval, DateTime

15 min, 2013/07/26 04:00:00 AM

15 min, 2013/07/26 04:15:00 AM

1 hr, 2013/07/26 04:00:00 AM

1 hr, 2013/07/26 05:00:00 AM

etc...

After that you could use special listbox with Interval field.

Re: Re: dynamically creating time slots based on user preference

jonathandienst — Wed, 21 Aug 2013 13:19:34 GMT

You can use Class to create a calculated dimension with a variable interval. See the attached qvw.

This script creates some data:

Intervals:

LOAD IntervalName, Evaluate(%Interval) As %Interval Inline

[

IntervalName, %Interval

15 mins, 15/1440

30 mins, 30/1440

1 hour, 1/24

12 hours, 1/2

1 day, 1

2 days, 2

];

Data:

LOAD * Inline

[

Time, Value

2013/07/31 08:00:00, 11

2013/07/31 08:05:00, 20

2013/07/31 08:20:00, 8

2013/07/31 09:00:00, 20

2013/07/31 09:01:00, 40

2013/07/31 09:25:00, 10

2013/07/31 11:10:00, 15

2013/07/31 15:10:00, 16

2013/07/31 15:50:00, 6

2013/08/01 07:45:00, 13

2013/08/01 09:00:00, 18

2013/08/02 08:10:00, 16

2013/08/02 08:10:00, 22

];

Create a list box for IntervalName. Create a chart with the dimension:

Timestamp(Class(Time, %Interval), 'YYYY/MM/DD hh:mm')

and the expression:

Sum(Value)

Now select different intervals to see the values summed for the specified intervals.

Hope that helps

Jonathan

Edit: corrected expression in first inline load (had 2440 minutes per day instead of 1440!!)

Re: dynamically creating time slots based on user preference

stigchel — Wed, 21 Aug 2013 13:32:41 GMT

Look at the calendar script provided by QlikView Components made by RobWunderlich here (Best practice scripts for common tasks)

qlikview-components - A script library for Qlikview development - Google Project Hosting

Re: Re: dynamically creating time slots based on user preference

Fri, 23 Aug 2013 06:38:32 GMT

hi,

I had tried this. But Timestamp(Class(Time, %Interval), 'YYYY/MM/DD hh:mm') is not giving any value

Re: dynamically creating time slots based on user preference

Fri, 23 Aug 2013 06:57:41 GMT

Hi,

Try to change your script for Date format and time format which is same as Jonathan's example. For me it's working fine.

Re: dynamically creating time slots based on user preference

Fri, 23 Aug 2013 09:24:34 GMT

ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='YYYY/MM/DD';

SET TimestampFormat='YYYY/MM/DD hh:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Intervals:

LOAD IntervalName, Evaluate(%Interval) As %Interval Inline

[

IntervalName, %Interval

15 mins, 15/1440

30 mins, 30/1440

1 hour, 1/24

12 hours, 1/2

1 day, 1

2 days, 2

];

Data:

LOAD * inline

[

Time, Value

2013/07/31 08:00:00, 11

2013/07/31 08:05:00, 20

2013/07/31 08:20:00, 8

2013/07/31 09:00:00, 20

2013/07/31 09:01:00, 40

2013/07/31 09:25:00, 10

2013/07/31 11:10:00, 15

2013/07/31 15:10:00, 16

2013/07/31 15:50:00, 6

2013/08/01 07:45:00, 13

2013/08/01 09:00:00, 18

2013/08/02 08:10:00, 16

2013/08/02 08:10:00, 22

];

let me know if this requires any changes.

Re: dynamically creating time slots based on user preference

Fri, 23 Aug 2013 09:30:16 GMT

Hi,

Try to change your formats as below:

SET TimeFormat='hh:mm:ss';

SET TimestampFormat='YYYY/MM/DD hh:mm:ss[.fff] TT';

Re: dynamically creating time slots based on user preference

Fri, 23 Aug 2013 09:33:24 GMT

hi ,

I tried the changes.

But i am getting null for

Timestamp(Class(Time, %Interval), 'YYYY/MM/DD hh:mm')

Re: dynamically creating time slots based on user preference

Fri, 23 Aug 2013 09:39:58 GMT

Hi,

Is it possible to attach your application?

Re: dynamically creating time slots based on user preference

Fri, 23 Aug 2013 09:49:06 GMT

sorry.. but i am not able to attach it

Re: dynamically creating time slots based on user preference

jonathandienst — Mon, 09 Sep 2013 14:14:18 GMT

This expression (Timestamp(Class(Time, %Interval), 'YYYY/MM/DD hh:mm'))assumes that you have selected one IntervalName value. If nothing is selected, it will not work.

Regards

Jonathan