topic Excluding Selection in QlikView

Excluding Selection

Thu, 22 May 2014 15:58:53 GMT

Hello all,

I have the following in my dimension:

if( (Store_Latitude > vLatMin and Store_Latitude < vLatMax) and ( Store_Longitude < vLonMax and Store_Longitude > vLonMin ), Store_FullName,null())

What is does is show all the stores within a radius of a selected Postal code. Works perfect except ...

When I associate Postal Code table with Store Table and others, the results are limited to just those in the area code.Is there a way I can/should exclude Postal Code from limiting the results?

Re: Excluding Selection

SunilChauhan — Thu, 22 May 2014 16:06:37 GMT

in expresion try use below

sum({<[Postal Code]=>}fieldname)

in above [Postal Code]=

used to exclude selection

hope this helps

Re: Excluding Selection

Thu, 22 May 2014 16:25:09 GMT

Thank you Sunil,

I knew it was going to come down to using set analysis; although I was hoping to do it another way. I did use what you said in a text object and it worked.

=Count({<[PostalCode_PostalCode]=> }distinct if( (Store_Latitude > vLatMin and Store_Latitude < vLatMax) and ( Store_Longitude < vLonMax and Store_Longitude > vLonMin ), Store_FullName))