Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikhans
Creator
Creator

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
sunny_talwar

How about this

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

View solution in original post

2 Replies
sunny_talwar

How about this

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

qlikhans
Creator
Creator
Author

Hi Sunny,

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

BR

Hans