topic Re: input box in combination with set analyses in QlikView

input box in combination with set analyses

qlikhans — Mon, 26 Feb 2018 09:15:59 GMT

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

Re: input box in combination with set analyses

sunny_talwar — Mon, 26 Feb 2018 13:18:45 GMT

How about this

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

Re: input box in combination with set analyses

qlikhans — Mon, 26 Feb 2018 13:35:20 GMT

Hi Sunny,

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

Hans