https://community.qlik.com/t5/App-Development/How-to-compare-date-with-null-values/m-p/1764231#M59097 <P>No, I want to display null value.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot_20201125-131526.jpg" style="width: 1080px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/44772i9DDDF360EB6A5B84/image-size/medium?v=v2&amp;px=400" role="button" title="Screenshot_20201125-131526.jpg" alt="Screenshot_20201125-131526.jpg" /></span></P><P> </P> Wed, 25 Nov 2020 07:47:30 GMT manju421 2020-11-25T07:47:30Z https://community.qlik.com/t5/App-Development/How-to-compare-date-with-null-values/m-p/1763992#M59071 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="IMG_20201124_170055__01__01.jpg" style="width: 4482px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/44717i68E33DFA4E9C5FD0/image-size/medium?v=v2&amp;px=400" role="button" title="IMG_20201124_170055__01__01.jpg" alt="IMG_20201124_170055__01__01.jpg" /></span></P><P>I need a if statement using which, I can fetch all 4 version. Is there anyway through which I can get version 1. In every case for version 1..Date2 will be null</P> Sat, 16 Nov 2024 17:47:08 GMT https://community.qlik.com/t5/App-Development/How-to-compare-date-with-null-values/m-p/1763992#M59071 manju421 2024-11-16T17:47:08Z https://community.qlik.com/t5/App-Development/How-to-compare-date-with-null-values/m-p/1764074#M59077 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/43068">@manju421</a>&nbsp;</P><P>Are you trying to replace null values of Date2 with Date1?</P><P>If so, try like below</P><P>if(Len(Trim(Date2))=0, Date1, Date2)&nbsp;</P> Tue, 24 Nov 2020 15:42:00 GMT https://community.qlik.com/t5/App-Development/How-to-compare-date-with-null-values/m-p/1764074#M59077 MayilVahanan 2020-11-24T15:42:00Z https://community.qlik.com/t5/App-Development/How-to-compare-date-with-null-values/m-p/1764231#M59097 <P>No, I want to display null value.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot_20201125-131526.jpg" style="width: 1080px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/44772i9DDDF360EB6A5B84/image-size/medium?v=v2&amp;px=400" role="button" title="Screenshot_20201125-131526.jpg" alt="Screenshot_20201125-131526.jpg" /></span></P><P> </P> Wed, 25 Nov 2020 07:47:30 GMT https://community.qlik.com/t5/App-Development/How-to-compare-date-with-null-values/m-p/1764231#M59097 manju421 2020-11-25T07:47:30Z