Script Issues with multiple fields

Mon, 14 Jan 2013 11:09:08 GMT

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??

Re: Script Issues with multiple fields

Anonymous — Mon, 14 Jan 2013 12:16:55 GMT

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

Jonathan

topic Re: Script Issues with multiple fields in QlikView

Script Issues with multiple fields

Re: Script Issues with multiple fields