topic Re: Date Field Expression in QlikView https://community.qlik.com/t5/QlikView/Date-Field-Expression/m-p/1360578#M417070 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>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. </P></BODY></HTML> Mon, 26 Jun 2017 18:04:09 GMT pandreozzi 2017-06-26T18:04:09Z Date Field Expression https://community.qlik.com/t5/QlikView/Date-Field-Expression/m-p/1360576#M417068 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Mon, 26 Jun 2017 17:15:52 GMT https://community.qlik.com/t5/QlikView/Date-Field-Expression/m-p/1360576#M417068 pandreozzi 2017-06-26T17:15:52Z Re: Date Field Expression https://community.qlik.com/t5/QlikView/Date-Field-Expression/m-p/1360577#M417069 <HTML><HEAD></HEAD><BODY><P>May be this as your sheet condition</P><P></P><P><STRONG>Max(Date) &lt; MakeDate(2099, 1, 1)</STRONG></P></BODY></HTML> Mon, 26 Jun 2017 17:22:39 GMT https://community.qlik.com/t5/QlikView/Date-Field-Expression/m-p/1360577#M417069 sunny_talwar 2017-06-26T17:22:39Z Re: Date Field Expression https://community.qlik.com/t5/QlikView/Date-Field-Expression/m-p/1360578#M417070 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>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. </P></BODY></HTML> Mon, 26 Jun 2017 18:04:09 GMT https://community.qlik.com/t5/QlikView/Date-Field-Expression/m-p/1360578#M417070 pandreozzi 2017-06-26T18:04:09Z Re: Date Field Expression https://community.qlik.com/t5/QlikView/Date-Field-Expression/m-p/1360579#M417071 <HTML><HEAD></HEAD><BODY><P>Might be easier if I can have a look at a sample?</P></BODY></HTML> Mon, 26 Jun 2017 18:27:58 GMT https://community.qlik.com/t5/QlikView/Date-Field-Expression/m-p/1360579#M417071 sunny_talwar 2017-06-26T18:27:58Z Re: Date Field Expression https://community.qlik.com/t5/QlikView/Date-Field-Expression/m-p/1360580#M417072 <HTML><HEAD></HEAD><BODY><P>Ok, let me put some screen shots together and upload them tomorrow. </P></BODY></HTML> Mon, 26 Jun 2017 18:40:31 GMT https://community.qlik.com/t5/QlikView/Date-Field-Expression/m-p/1360580#M417072 pandreozzi 2017-06-26T18:40:31Z Re: Date Field Expression https://community.qlik.com/t5/QlikView/Date-Field-Expression/m-p/1360581#M417073 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Mon, 26 Jun 2017 19:28:24 GMT https://community.qlik.com/t5/QlikView/Date-Field-Expression/m-p/1360581#M417073 pandreozzi 2017-06-26T19:28:24Z