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: 
TCDBAG
Contributor
Contributor

problems with a custom field/formula with multiple IF's

Dear all,

we currently have the following data that we wan to work with:

1) a table that shows a few columns with different status information and dates
2) we would like to add custom columns showing a result of a formula: multiple IF functions in a cluster shall determine the value and give out a result of a query:      =If((Match([Status],"ITEM New","ITEM Open", "ITEM in Analysis", "ITEM Analysis Complete", "ITEM in Implementation") AND ([overdue] ="overdue")),"overdue","not yet overdue")

Columns:
[Status] = this is a field that is pulled from the source data and just displayed here.
[overdue] = this is a custom field that is added in the table directly (basically a calculated field). The value for this field is calculated using this formula:      =if (date([Actual Due Date], 'DD.MM.YYYY')>Today(1), 'good', 'overdue')

Well, the error message does not really help and i have not yet found something in this forum that solves my problem. Can somebody please give me a hand and let me know what i am doing wrong here?  🙂

0 Replies