Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

zagzebski
Contributor

Using or in set analysis


I am drawing a blank but don't feel like this should be that hard..

Provider ID

ABC

DEF

Region

South

West

North

East

I wanted to show the results of sales where :

Region = South or West or  Provider ID = ABC

1 Solution

Accepted Solutions

Re: Using or in set analysis

Yes you have to use Union operator in between the set analysis

=Sum({<Region={'South','West'}> + <ProviderID = {'ABC'} >} Sales)


Hope that helps

5 Replies
israrkhan
Valued Contributor II

Re: Using or in set analysis

Try like this..

=Sum({<Region={'South','West'}, ProviderID = {'ABC'} >}, Sales)

Employee
Employee

Re: Using or in set analysis

=sum({<Region={'South','West'}>+<ProviderID = {'ABC'} >}Sales)

zagzebski
Contributor

Re: Using or in set analysis


Thanks for the feedback. Unfortunately I think this wouldn't work because it says the record would need:

Region = South or West  AND Provider ID = ABC

I need the expression to be

Region = South or West  OR Provider ID = ABC

Steve

israrkhan
Valued Contributor II

Re: Using or in set analysis

ooops...

i got the wrong..

try expression by Clever, it should work...

Re: Using or in set analysis

Yes you have to use Union operator in between the set analysis

=Sum({<Region={'South','West'}> + <ProviderID = {'ABC'} >} Sales)


Hope that helps

Community Browser