topic Re: Set Expression in QlikView https://community.qlik.com/t5/QlikView/Set-Expression/m-p/1433533#M430892 <HTML><HEAD></HEAD><BODY><P>May be this? I assume Date fields are good</P><P></P><P><STRONG>Count({&lt;RENEWED_PREMI|UM = {'&gt;0'}, RENEWED_DATE = {"=$('&lt;' &amp; =Max(<SPAN style="font-size: 13.3333px;">RENEWED_DATE</SPAN>))"}&gt;} DISTINCT POLICT_NO)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>OR</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><SPAN style="font-size: 13.3333px;">Count({&lt;RENEWED_PREMI|UM = {'&gt;0'}, RENEWED_DATE = {'&lt;$(=Max(</SPAN><SPAN style="font-size: 13.3333px;">RENEWED_DATE</SPAN><SPAN style="font-size: 13.3333px;">))'}&gt;} DISTINCT POLICT_NO)</SPAN></STRONG></P></BODY></HTML> Mon, 21 Aug 2017 06:32:19 GMT Anil_Babu_Samineni 2017-08-21T06:32:19Z Set Expression https://community.qlik.com/t5/QlikView/Set-Expression/m-p/1433532#M430891 <HTML><HEAD></HEAD><BODY><P>Dear Friends</P><P></P><P>My following set expression show zero results. I think there is an error there. Pls help me to rectify it</P><P></P><P><IMG alt="Screenshot_1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/173986_Screenshot_1.png" style="height: 55px; width: 620px;" /><IMG alt="Screenshot_2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/173993_Screenshot_2.png" style="height: auto;" /></P></BODY></HTML> Mon, 21 Aug 2017 06:28:06 GMT https://community.qlik.com/t5/QlikView/Set-Expression/m-p/1433532#M430891 upaliwije 2017-08-21T06:28:06Z Re: Set Expression https://community.qlik.com/t5/QlikView/Set-Expression/m-p/1433533#M430892 <HTML><HEAD></HEAD><BODY><P>May be this? I assume Date fields are good</P><P></P><P><STRONG>Count({&lt;RENEWED_PREMI|UM = {'&gt;0'}, RENEWED_DATE = {"=$('&lt;' &amp; =Max(<SPAN style="font-size: 13.3333px;">RENEWED_DATE</SPAN>))"}&gt;} DISTINCT POLICT_NO)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>OR</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><SPAN style="font-size: 13.3333px;">Count({&lt;RENEWED_PREMI|UM = {'&gt;0'}, RENEWED_DATE = {'&lt;$(=Max(</SPAN><SPAN style="font-size: 13.3333px;">RENEWED_DATE</SPAN><SPAN style="font-size: 13.3333px;">))'}&gt;} DISTINCT POLICT_NO)</SPAN></STRONG></P></BODY></HTML> Mon, 21 Aug 2017 06:32:19 GMT https://community.qlik.com/t5/QlikView/Set-Expression/m-p/1433533#M430892 Anil_Babu_Samineni 2017-08-21T06:32:19Z Re: Set Expression https://community.qlik.com/t5/QlikView/Set-Expression/m-p/1433534#M430893 <HTML><HEAD></HEAD><BODY><P>Thanks Anil</P><P></P><P>Your second option works</P></BODY></HTML> Mon, 21 Aug 2017 06:39:10 GMT https://community.qlik.com/t5/QlikView/Set-Expression/m-p/1433534#M430893 upaliwije 2017-08-21T06:39:10Z Re: Set Expression https://community.qlik.com/t5/QlikView/Set-Expression/m-p/1433535#M430894 <HTML><HEAD></HEAD><BODY><P>I think first one also should work, May be remove = sign for your understand you can learn yourself</P></BODY></HTML> Mon, 21 Aug 2017 06:41:08 GMT https://community.qlik.com/t5/QlikView/Set-Expression/m-p/1433535#M430894 Anil_Babu_Samineni 2017-08-21T06:41:08Z