Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
viswamtulasi
Contributor II
Contributor II

Multiple condition on expression

I would like to use the below conditions on expressions –

  1. On search box file expression –  

Exclude few regions –

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

  1. 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.

1 Reply
sunny_talwar

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