Select start date and end date in qlikview calender object

[Anonymous]

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

[ashwanin]

Can you post sample?

Creating A Master Calendar

[its_anandrjs]

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

Hope this helps

[muniyandi]

Hi Anitha,

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

Thanks,

Muni

[its_anandrjs]

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

[Anonymous]

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.

[its_anandrjs]

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

[muniyandi · Accepted solution]

Hi,

Kindly verify my attachment file.

Regards,

Muni

[Anonymous]

Great Thanks for you help.

[#10]

Hi,

Please Find the Attachment For ur Issue Solution Example.

Regards,

Damu