Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
anitharamasamy
Creator
Creator

Select start date and end date in qlikview calender object

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

1 Solution

Accepted Solutions
muniyandi
Creator III
Creator III

Hi,

Kindly verify my attachment file.

Regards,

Muni

View solution in original post

9 Replies
ashwanin
Specialist
Specialist

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
Creator III
Creator III

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

anitharamasamy
Creator
Creator
Author

Hi,

Please find the sample below.

MonthNationalStateHospital
13-Jan13.213.413.3
13-Feb12.112.413.6
13-Mar11.311.513.1
13-Apr13.213.113
13-May11.411.612.9
13-Jun12.111.512.7

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

Qlikview.png

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
Creator III
Creator III

Hi,

Kindly verify my attachment file.

Regards,

Muni

View solution in original post

anitharamasamy
Creator
Creator
Author

Great Thanks for you help.

Not applicable

Hi,

Please Find the Attachment For ur Issue Solution Example.

Regards,

Damu