topic Re: Using or in set analysis in QlikView

Using or in set analysis

zagzebski — Mon, 28 Oct 2013 17:43:39 GMT

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

israrkhan — Mon, 28 Oct 2013 17:47:08 GMT

Try like this..

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

Clever_Anjos — Mon, 28 Oct 2013 17:51:11 GMT

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

zagzebski — Mon, 28 Oct 2013 17:51:15 GMT

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 — Mon, 28 Oct 2013 17:53:26 GMT

ooops...

i got the wrong..

try expression by Clever, it should work...

CELAMBARASAN — Mon, 28 Oct 2013 17:59:46 GMT

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

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

Hope that helps