Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
pandreozzi
Creator
Creator

Date Field Expression

I want to build an expression that hides a sheet based on a fixed date of 01/01/2099. So any date less than this date will show the sheet and any date greater than this date will hide the sheet. Can anyone assist?

5 Replies
sunny_talwar

May be this as your sheet condition

Max(Date) < MakeDate(2099, 1, 1)

pandreozzi
Creator
Creator
Author

Hi Sunny. this is close but what happens is because the date field (BILLING_END) has set values of 01/01/2099 the sheet is hidden all the time. What I am looking for is for the sheet to hid based on a selection.

Example: Customer 1 has assets with a billing start date of 01/01/2015 and an end date or 12/31/2099 in this case the sheet can stay hidden but if that same customer has an asset with a billing start date of 01/01/2015 and an end date of 01/01/2016 the sheet should be displayed. This can be complicated as my default view is to always show the sheet no matter what the condition is.

sunny_talwar

Might be easier if I can have a look at a sample?

pandreozzi
Creator
Creator
Author

Ok, let me put some screen shots together and upload them tomorrow.

pandreozzi
Creator
Creator
Author

Hi Sunny. I was able to put some screen shots together today but please do not feel like you need to reply today. If you have questions let me know.