input box in combination with set analyses

[qlikhans]

Hi all,

formula 1:  Sum({$<[Clearing Document]={''}, [CALENDAR_YEAR_MONTH_Posting_Date]>}[Amount in local currency]*[Exchange rate]) works and gives me all unpaid items.

Formula 2: =if(Peildatum>=[Payment date], 'y','n'), works also. 'y' marked is overdue

Peildatum is entered via an input box

how can I best combine the two formulae so that the result is : unpaid and overdue

thanks in advance

[sunny_talwar · Accepted solution]

How about this

Sum({$<[Clearing Document] = {''}, [CALENDAR_YEAR_MONTH_Posting_Date]>} If(Peildatum >= [Payment date], [Amount in local currency] * [Exchange rate]))

[qlikhans]

Hi Sunny,

it works thank you. I had put the if statement at the wrong location.

BR

Hans