topic Re: Selecting Arbitrary Time range from multibox(Year,Quater,month,day) in QlikView

Selecting Arbitrary Time range from multibox(Year,Quater,month,day)

Wed, 14 Oct 2015 02:47:02 GMT

Hello everyone,

Can someone please share knowledge..

How can i select arbitrary date ranges from Multibox(Year,quater,month,day)..Can you please share any qvw or video to implement...

thanks

Venkat

jgd‌ krishna_2644‌ qlikviewwizard‌ rajiqliview‌ anapaula‌ ! !

Re: Selecting Arbitrary Time range from multibox(Year,Quater,month,day)

qlikviewwizard — Wed, 14 Oct 2015 03:10:04 GMT

Hi,

Please check the attached file.

Script:

EMP:

LOAD EMPNO,

ENAME,

JOB,

MGR,

date(DATE) as START_DATE,

month(date(DATE)) as START_MONTH,

'Q' & Ceil(month(date(DATE))/3) as START_QUARTER,

year(date(DATE)) as START_YEAR,

date(DATE) as END_DATE,

month(date(DATE)) as END_MONTH,

'Q' & Ceil(month(date(DATE))/3) as END_QUARTER,

year(date(DATE)) as END_YEAR,

SALES,

COMM,

DEPTNO

FROM

EMP.xlsx

(ooxml, embedded labels, table is EMP);

DEPT:

LOAD DEPTNO,

DNAME,

COUNTRY

FROM

EMP.xlsx

(ooxml, embedded labels, table is DEPT);

Re: Selecting Arbitrary Time range from multibox(Year,Quater,month,day)

Wed, 14 Oct 2015 03:24:55 GMT

start Date and End date should be different(time range)

For your above Qvw...when i select Start_date it automatically selecting End_Date same as Start_Data...i need range of time..(like StartDate: 01-sep-2012, EndDate: 09-jul-2014)

Thanks

Venkat

Re: Selecting Arbitrary Time range from multibox(Year,Quater,month,day)

qlikviewwizard — Wed, 14 Oct 2015 05:07:05 GMT

Hi Sai,

Watch this:

Selecting Arbitrary Date Ranges

Re: Selecting Arbitrary Time range from multibox(Year,Quater,month,day)

settu_periasamy — Wed, 14 Oct 2015 05:15:16 GMT

Hi Sai,

Check the Attachment with the help of qlikviewwizard Data.

You can do it Multiple ways. I applied ListBox and MultiBox Options..

Re: Selecting Arbitrary Time range from multibox(Year,Quater,month,day)

Digvijay_Singh — Wed, 14 Oct 2015 05:28:42 GMT

Check this also -

Re: Selecting Arbitrary Time range from multibox(Year,Quater,month,day)

Wed, 14 Oct 2015 12:26:07 GMT

Hi Digvijay,

Created using Triggers right?

Can you please explain how can i achieve this technique...

Thanks

Venkat

Re: Selecting Arbitrary Time range from multibox(Year,Quater,month,day)

Digvijay_Singh — Wed, 14 Oct 2015 12:36:22 GMT

Hi,

I used alternate states for Start and End date Multi boxes. Range Selection is shown In straight table(looking like a listbox!), I created set analysis based expression to build range from min date of multibox 1 and max date of multibox 2. Hidden one column of straight table to make it appear like a list box.

Expression used in straight table is -

- Aggr(Only({<Date={'>=$(=Min({Start}Date))<=$(=Max({End}Date))'}>}Date),Year,Quarter,Month,Date)

- Where Start and End are alternate states.

Re: Selecting Arbitrary Time range from multibox(Year,Quater,month,day)

Wed, 14 Oct 2015 13:41:41 GMT

Not only single object...whole Qvw should be filter according to this these filters(StartDate and EndDate).

Re: Selecting Arbitrary Time range from multibox(Year,Quater,month,day)

Digvijay_Singh — Wed, 14 Oct 2015 17:57:40 GMT

As of now I think the expression used to identify date range needs to be used in other objects to link them with selected date range. I need to check how it can be automatically linked to filter dates used in other objects.

Re: Selecting Arbitrary Time range from multibox(Year,Quater,month,day)

Wed, 14 Oct 2015 18:01:03 GMT

thank you...ya iam looking to change all objects in document according to these StartDate and EndDate.