Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Zahmed14
Contributor III
Contributor III

how to add Calender object

Hello Guys , 

How can i add a calander date as filter having all dates to choose between

My date field does not have all dates availble and user need to choose from calander with all dates, below is my date field

D.JPG

 

Labels (2)
1 Solution

Accepted Solutions
Zahmed14
Contributor III
Contributor III
Author

I wrote below load and it worked for me

Let vMinDate=Num(MakeDate(2010,1,1));
Let vMaxDate= Num(Today());

 

Calander:
Load
Date(($(vMinDate)+RowNo()-1),'DD/MM/YYYY') as Date,
Month($(vMinDate)+RowNo()-1) as Month,
Year($(vMinDate)+RowNo()-1) as Year
AutoGenerate $(vMaxDate)-$(vMinDate)+1;

View solution in original post

3 Replies
David_Fergen
Former Employee
Former Employee

Hi Zahmed14,

For the dates, there is a guide here that will tell you how to set the dates of ranges that you can choose.  This should provide some insight for you!

Let me know if that answers your question?

Thanks,

David

Ksrinivasan
Specialist
Specialist

hi,

if you want to select all date first click lens icon

Ksrinivasan_0-1611120971669.png

then click ...

Ksrinivasan_1-1611121017179.png

then click select all

Ksrinivasan_2-1611121063928.png

all points are selected

Ksrinivasan_3-1611121104266.png

 

ksrinivasan

Zahmed14
Contributor III
Contributor III
Author

I wrote below load and it worked for me

Let vMinDate=Num(MakeDate(2010,1,1));
Let vMaxDate= Num(Today());

 

Calander:
Load
Date(($(vMinDate)+RowNo()-1),'DD/MM/YYYY') as Date,
Month($(vMinDate)+RowNo()-1) as Month,
Year($(vMinDate)+RowNo()-1) as Year
AutoGenerate $(vMaxDate)-$(vMinDate)+1;