Qliksense Calendar Chart

[Manasareddy09]

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. 

[Ivan_Bozov]

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.

[Manasareddy09]

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]

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...

[Manasareddy09]

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]

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

Also, try using the autoCalendar.