Re: How to write expression - Qlik Community

Report Inappropriate Content · ‎2013-10-10

Hi,

I have one requirement like below.

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’ . The monthly payment will be found in field TransactionAmount.

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.

Could anyone help me how to write the expression please.

Thanks.

Report Inappropriate Content · ‎2013-10-10

Please could anyone help

tresesco · ‎2013-10-10

Amelia,

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.

Please read how to get answer to your post

Report Inappropriate Content · ‎2013-10-10

Hi,

Sorry for not making my posts harly readable. From this time onwards I will add my posts very clear.

Thanks.

Report Inappropriate Content · ‎2013-10-10

could you upload a sample?