Multiple condition on expression

viswamtulasi — Wed, 11 Jul 2018 06:50:11 GMT

I would like to use the below conditions on expressions –

On search box file expression –

Exclude few regions –

=if ([Region] <> 'AP', 'EU', 'SA' ‘CA’, [Region])

On Chart expression –

Need the multiple conditions which includes AND and OR conditions

Sum({<
[Cycle] = {'YES'},
[Funding_Region] -= {'AP', 'EU', 'SA'},
[Skill_Team] -= {'BANK', 'Non Bank'},
[ICode] = {'*SBI*'} > + < [ICode] -= {'*SBI*'}, [Product_Service] = {'Customer Value'}
>} [Budget])/1000000

Thanks in advance to support on the above expressions.

Re: Multiple condition on expression

sunny_talwar — Wed, 11 Jul 2018 11:32:57 GMT

May be this

Sum({<[Cycle] = {'YES'}, [Funding_Region] -= {'AP', 'EU', 'SA'}, [Skill_Team] -= {'BANK', 'Non Bank'}, [ICode] = {'*SBI*'}, Region -= {'AP', 'EU', 'SA', 'CA'}> + <[ICode] -= {'*SBI*'}, [Product_Service] = {'Customer Value'}, Region -= {'AP', 'EU', 'SA', 'CA'}>} [Budget])/1000000

topic Multiple condition on expression in QlikView

Multiple condition on expression

Re: Multiple condition on expression