topic How to write expression in QlikView https://community.qlik.com/t5/QlikView/How-to-write-expression/m-p/538526#M1137881 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>I have one requirement like below.</P><P></P><P>Last Payment Date = last monthly contribution received obtained by selecting MAX(TransDate) from EXP.CASHBOOK_TRANSACTIONS where AccountID and ActualAccountID = specific account and TransTypeDomain=’Receipt’ and TransType=’DD’ .&nbsp; The monthly payment will be found in field TransactionAmount.</P><P></P><P>I need to get the dates for Last Payment Date in Straight/Pivot table. when I used this field it's shpowing blank values. but the column contins dates from 2005-2013 in SQL Table.</P><P></P><P>Could anyone help me how to write the expression please.</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 10 Oct 2013 08:46:07 GMT 2013-10-10T08:46:07Z How to write expression https://community.qlik.com/t5/QlikView/How-to-write-expression/m-p/538526#M1137881 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>I have one requirement like below.</P><P></P><P>Last Payment Date = last monthly contribution received obtained by selecting MAX(TransDate) from EXP.CASHBOOK_TRANSACTIONS where AccountID and ActualAccountID = specific account and TransTypeDomain=’Receipt’ and TransType=’DD’ .&nbsp; The monthly payment will be found in field TransactionAmount.</P><P></P><P>I need to get the dates for Last Payment Date in Straight/Pivot table. when I used this field it's shpowing blank values. but the column contins dates from 2005-2013 in SQL Table.</P><P></P><P>Could anyone help me how to write the expression please.</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 10 Oct 2013 08:46:07 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression/m-p/538526#M1137881 2013-10-10T08:46:07Z Re: How to write expression https://community.qlik.com/t5/QlikView/How-to-write-expression/m-p/538527#M1137882 <HTML><HEAD></HEAD><BODY><P>Please could anyone help</P></BODY></HTML> Thu, 10 Oct 2013 09:19:30 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression/m-p/538527#M1137882 2013-10-10T09:19:30Z Re: How to write expression https://community.qlik.com/t5/QlikView/How-to-write-expression/m-p/538528#M1137883 <HTML><HEAD></HEAD><BODY><P>Amelia,</P><P>See, so long no body has responded to your post. Possible reasons: 1) No body knew the answer, or 2) No body could really understand your requirement. And here the second reason is the one I believe. Your post is hardly readable, please make sure that you can reach to the people when you expect to be answered. Please explain in a better way.</P><P>Please read <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-2380">how to get answer to your post</A></P></BODY></HTML> Thu, 10 Oct 2013 09:25:07 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression/m-p/538528#M1137883 tresB 2013-10-10T09:25:07Z Re: How to write expression https://community.qlik.com/t5/QlikView/How-to-write-expression/m-p/538529#M1137884 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Sorry<IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" />&nbsp; for not making my posts harly readable. From this time onwards I will add my posts very clear.</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 10 Oct 2013 09:50:43 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression/m-p/538529#M1137884 2013-10-10T09:50:43Z Re: How to write expression https://community.qlik.com/t5/QlikView/How-to-write-expression/m-p/538530#M1137885 <HTML><HEAD></HEAD><BODY><P>could you upload a sample? </P></BODY></HTML> Thu, 10 Oct 2013 09:53:28 GMT https://community.qlik.com/t5/QlikView/How-to-write-expression/m-p/538530#M1137885 2013-10-10T09:53:28Z