topic Re: Help in Expression? in QlikView

Help in Expression?

narender123 — Mon, 11 Nov 2013 07:19:13 GMT

Hi All,

I have made a calender which is based on "receipt data" of a table.

There is a paid date in another table.

doc id receive date amount

12 5-1-2012 100

13 5-3-2012 200

25 26-2-2012 288

---------------------------------------------------------------------------------

doc id paid date amount

12 7-1-2012 100

13 5-4-2012 400

14 29-6-2012 888

-------------------------------------------------------------------------------------------

I want to calculate amount where receipt date and paid date both are of the same month.

for those where receipt date and paid date are not belong to same month then not show there amount.

if i select september month then only show those amount whose paid date and receipt date fall in the same month.

Please suggest me to sort out this.\

Thanks in Advance.

Narender

Re: Help in Expression?

bbi_mba_76 — Mon, 11 Nov 2013 08:13:46 GMT

Hi,

to simplify you could add a Period field in the script, ie year*100+month.

Re: Help in Expression?

salto — Mon, 11 Nov 2013 08:28:32 GMT

Hi,

Load

"doc id" as DocID,

"receive date" as ReceiveDate,

Month("receive date") as MonthReceived,

"amount" as AmountReceived from RECEIVED_Table;

Load

"doc id" as DocID,

"paid date" as ReceiveDate,

Month("paid date") as MonthPaid,

"amount" as AmountPaid from PAID_Table;

And set the expression to show only those DocID where MonthPaid and MonthReceived fields are the same.

Hope this helps!

Re: Help in Expression?

Mon, 11 Nov 2013 08:35:40 GMT

Hi,

Which amount you want to show amount belonging to the received date or amount belonging to the paid date?

Or in your case both the received date and paid date is in same month then the amount also same ah?

please explain once

Re: Help in Expression?

narender123 — Mon, 11 Nov 2013 12:46:13 GMT

Hi BBI_MBA,

Sorry i didnt get your point.please expalin with example.

Thanks

Re: Help in Expression?

narender123 — Mon, 11 Nov 2013 12:48:30 GMT

And set the expression to show only those DocID where MonthPaid and MonthReceived fields are the same.

how to achiave it as you said in bold letter.I have already joined but theproblem with the expression to show both date are of same month.

Thanks.

Re: Re: Help in Expression?

salto — Mon, 11 Nov 2013 13:09:14 GMT

PFA my approach.

Hope this helps!