topic Flag date differences in QlikView https://community.qlik.com/t5/QlikView/Flag-date-differences/m-p/118825#M18306 <HTML><HEAD></HEAD><BODY><P>good day,</P><P></P><P>please find attached data with required results.</P><P></P><P>i have no idea how to populate the pivot table in qlikview to get my desired results.</P></BODY></HTML> Wed, 08 Aug 2018 12:14:21 GMT ranibosch 2018-08-08T12:14:21Z Flag date differences https://community.qlik.com/t5/QlikView/Flag-date-differences/m-p/118825#M18306 <HTML><HEAD></HEAD><BODY><P>good day,</P><P></P><P>please find attached data with required results.</P><P></P><P>i have no idea how to populate the pivot table in qlikview to get my desired results.</P></BODY></HTML> Wed, 08 Aug 2018 12:14:21 GMT https://community.qlik.com/t5/QlikView/Flag-date-differences/m-p/118825#M18306 ranibosch 2018-08-08T12:14:21Z Re: Flag date differences https://community.qlik.com/t5/QlikView/Flag-date-differences/m-p/118826#M18307 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>you can try this on the script:</P><P></P><P>if(len(trim(close_date))&lt;&gt;0, close_date - open_date) as Difference_days_open_vs_close_date,</P><P>if(len(trim(close_date))=0,Date(today()) - open_date) as <SPAN style="font-size: 13.3333px;">Difference_days_open_vs_today_date,</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">PS: make sure your Open_date and Close_date are already evaluated as dates with the correct format, otherwise you will need to use Date#() and Date() functions</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P></BODY></HTML> Wed, 08 Aug 2018 12:28:02 GMT https://community.qlik.com/t5/QlikView/Flag-date-differences/m-p/118826#M18307 YoussefBelloum 2018-08-08T12:28:02Z