Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Manasareddy09
Contributor III
Contributor III

Qliksense Calendar Chart

Hello Qlik Enthusiasts , 

I want to have a little calendar where i can choose a particular date for example, 02-04-2022 and then get all the records which would be expired until this date. The date is as follows . 

Student , Document, Expiration Date, Document Status 

101, Doc1, 12-03-2021, Expired 

102, Doc2 , 12-09-2022, Valid

103, Doc3, 12-11-2021, Valid 

104, Doc4, 31-12-2021, Valid

 

for now i am calculating status if the expiry date is less than today then its expired. But i want to have a calendar where i can choose a particular date and get all the expired certifcates until that particular date. For example,if i select 31-12-2021 then i would like to get the following output . 

Student , Document, Expiration Date, Document Status 

101, Doc1, 12-03-2021, Expired 

102, Doc2 , 12-09-2022, Valid

103, Doc3, 12-11-2021, Expired

104, Doc4, 31-12-2021, Expired

 

Please help me solve this , Thank you for your valuable time in Advance. 

5 Replies
Ivan_Bozov
Luminary
Luminary

Hi, there is a date picker under Custom objects > Qlik dashboard bundle. In the object options there is a single date / interval toggle. Choose interval and you should be able to achieve what you describe above.

vizmind.eu
Manasareddy09
Contributor III
Contributor III
Author

hi , 

Thank you for the response, I found the date picker, but the problem is i dont see my date field in the select drop down. 

I dont have an option to edit it as well. 

can you think of why it doesnt show the date column ?

Ivan_Bozov
Luminary
Luminary

Make sure the filed is formatted as a date.

 

"The list contains only fields that are recognized as a date field by Qlik Sense." - https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/Visualizations/Dashboa...

vizmind.eu
Manasareddy09
Contributor III
Contributor III
Author

Hello , 

I have tried to convert it to date format using following functions, but i still cannot see it. 

Date(Expiration Date)

Date#(Expiration Date)

Date(Floor (Expiration Date))

Date(Date#(Floor (Expiration Date)))

 

But it still doesn't recognise it .

Thank you.

Ivan_Bozov
Luminary
Luminary

You need to do it in the script so that the field is loaded as a date.

Also, try using the autoCalendar.

vizmind.eu