topic Re: Set Analysis Expression Issue in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Expression-Issue/m-p/1186767#M884478 <HTML><HEAD></HEAD><BODY><P>Can you may be share a sample of how your data looks like to offer a solution?</P></BODY></HTML> Fri, 16 Sep 2016 19:04:21 GMT sunny_talwar 2016-09-16T19:04:21Z Set Analysis Expression Issue https://community.qlik.com/t5/QlikView/Set-Analysis-Expression-Issue/m-p/1186766#M884477 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to write an expression&nbsp; like this but it is not working. Please help me with the same.</P><P></P><P><SPAN style="font-size: 12.0pt; font-family: 'Arial',sans-serif; color: black;">Sum({&lt;[DIM Date.Full Date]={"$(=Max(P({&lt;[DIM Date.Full Date]={"&lt;$(=Max([DIM Date.Full Date]))"}&gt;})))"}&gt;}[Account Total Unbilled Amount])</SPAN></P><P><SPAN style="font-size: 12.0pt; font-family: 'Arial',sans-serif; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 12.0pt; font-family: 'Arial',sans-serif; color: black;">What I want to do is to have data for the closest date even when a date is selected where there is no data.</SPAN></P><P><SPAN style="font-size: 12.0pt; font-family: 'Arial',sans-serif; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 12.0pt; font-family: 'Arial',sans-serif; color: black;">Regards,</SPAN></P><P><SPAN style="font-size: 12.0pt; font-family: 'Arial',sans-serif; color: black;">Manu<BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Expression-Issue/m-p/1186766#M884477 Anonymous 2020-11-25T16:16:04Z Re: Set Analysis Expression Issue https://community.qlik.com/t5/QlikView/Set-Analysis-Expression-Issue/m-p/1186767#M884478 <HTML><HEAD></HEAD><BODY><P>Can you may be share a sample of how your data looks like to offer a solution?</P></BODY></HTML> Fri, 16 Sep 2016 19:04:21 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Expression-Issue/m-p/1186767#M884478 sunny_talwar 2016-09-16T19:04:21Z