topic Re: Select start date and end date in qlikview calender object in QlikView

Select start date and end date in qlikview calender object

Anonymous — Tue, 01 Apr 2014 09:34:56 GMT

Hi Friends,

I have two calendar object which takes date from Excel.

How can i select the start date and end date from calender object.

The problem im facing is, whatever i choose in first calendar , the same is automatically selected in second calendar.

Please help me out.

Thanks

Re: Select start date and end date in qlikview calender object

ashwanin — Tue, 01 Apr 2014 09:39:47 GMT

Can you post sample?

Creating A Master Calendar

Re: Select start date and end date in qlikview calender object

its_anandrjs — Tue, 01 Apr 2014 09:39:51 GMT

Take two calendar object and in Min date use Min(Yourdatefield) and for Max(Yourdatfield)

Hope this helps

Re: Select start date and end date in qlikview calender object

muniyandi — Tue, 01 Apr 2014 09:40:44 GMT

Hi Anitha,

Use variable min & max date . or post some sample file.

Thanks,

Muni

Re: Select start date and end date in qlikview calender object

its_anandrjs — Tue, 01 Apr 2014 09:54:02 GMT

Take two variables

vMinDate = Min(Yourdatefield)

vMaxDate = Max(Yourdatefield)

and in calendar object in Min Value use variable vMinDate

and in Max Value use =vMaxDate

and in variable select =vMinDate

New update please check now

Thanks & Regards

Re: Select start date and end date in qlikview calender object

Anonymous — Tue, 01 Apr 2014 10:07:05 GMT

Hi,

Please find the sample below.

Month	National	State	Hospital
13-Jan	13.2	13.4	13.3
13-Feb	12.1	12.4	13.6
13-Mar	11.3	11.5	13.1
13-Apr	13.2	13.1	13
13-May	11.4	11.6	12.9
13-Jun	12.1	11.5	12.7

Below are the 2 calenders, i need to choose form date from calendar1 and to date from calendar2.

Re: Select start date and end date in qlikview calender object

its_anandrjs — Tue, 01 Apr 2014 10:17:07 GMT

You need a Datefield for calendar object but in sample date there is no date field you have to do like below

Eg:-

let vMinCal1 = Peek('Date',0,'Temp');

Let vMaxCal1 = Peek('Date',-1,'Temp');

let vMinCal2 = Peek('Date2',0,'Temp');

Let vMaxCal2 = Peek('Date2',-1,'Temp');

and in calendar object in Min Value use variable vMinDate

and in Max Value use = vMinCal1

and in variable select = vMaxCal1

same for calender object two

and in Max Value use = vMinCal2

and in variable select = vMaxCal2

But data lies between this date then it will show to you.

Hope this helps

Re: Select start date and end date in qlikview calender object

muniyandi — Tue, 01 Apr 2014 11:13:35 GMT

Hi,

Kindly verify my attachment file.

Regards,

Muni

Re: Select start date and end date in qlikview calender object

Anonymous — Tue, 01 Apr 2014 11:33:34 GMT

Great Thanks for you help.

Re: Select start date and end date in qlikview calender object

Tue, 01 Apr 2014 12:09:02 GMT

Hi,

Please Find the Attachment For ur Issue Solution Example.

Regards,

Damu