Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Script Issues with multiple fields

Hi, I am after some advice on pulling through some information. I currently have the following definition in my expressions:

 

Sum

(if (top_down.expence_category <> 'INCOME',top_down.direct))+Sum (if (top_down.expence_category <> 'INCOME',top_down.indirect))+Sum (if (top_down.expence_category <> 'INCOME',top_down.overhead))

However where i have <> 'INCOME' I need multiple values in here i.e. 'INCOME', 'INCOMEA', 'INCOMEC'

It doesnt appear NOT LIKE or DOES NOT CONTAIN is an option.

Could someone please advise on best way to do this??

 

1 Reply
Anonymous
Not applicable
Author

How about Left(top_down.expence_category,4)='Income' ?

Jonathan