Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

qlikhans
Contributor

input box in combination with set analyses

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

1 Solution

Accepted Solutions

Re: input box in combination with set analyses

How about this

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

2 Replies

Re: input box in combination with set analyses

How about this

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

qlikhans
Contributor

Re: input box in combination with set analyses

Hi Sunny,

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

BR

Hans

Community Browser