QlikMaps: Restricting dimension values

[satishkurra]

Hi

I need to restrict the dimension values for the dimensions County and CountyBoundary below.

Ex: I have 100 Counties and 1000 County Borders, How to restrict the values to show only below values?

Attached is the screen shot of dimension and boundary path

I'm currently using the below expressions in dimensions, It is not working

For County:

=Only({<County={'DUTCHESS','ORANGE','SULLIVAN','WESTCHESTER','PUTNAM','ROCKLAND','ULSTER'}>}County)

For CountyBoundary:

=Only({<County={'DUTCHESS','ORANGE','SULLIVAN','WESTCHESTER','PUTNAM','ROCKLAND','ULSTER'}>}CountyBoundary)

Can someone help me on this?

Thanks

Satish

[settu_periasamy]

Hi,

May be try like this..

=if(MixMatch(County,'DUTCHESS','ORANGE','SULLIVAN',

     'WESTCHESTER','PUTNAM','ROCKLAND','ULSTER'),County)

[jagan]

HI,

You can try a calculated dimension

=If(MixMatch(County, 'DUTCHESS','ORANGE','SULLIVAN','WESTCHESTER','PUTNAM','ROCKLAND','ULSTER'), County, Null())

=If(MixMatch(County, 'DUTCHESS','ORANGE','SULLIVAN','WESTCHESTER','PUTNAM','ROCKLAND','ULSTER'), CountyBoundary, Null())

or you can restrict in expresison like below

Sum({<County={'DUTCHESS','ORANGE','SULLIVAN','WESTCHESTER','PUTNAM','ROCKLAND','ULSTER'}>} SomeMeasureName)

Among this the best method is to restrict them in Set Analysis expressions, it is faster.

Hope this helps you.

Regards,

jagan.

[satishkurra]

The below worked...

=Aggr(Only({StateAbbre={'NY'},County={'DUTCHESS','ORANGE','SULLIVAN','WESTCHESTER','PUTNAM','ROCKLAND','ULSTER'}>} County), County)

=Aggr(Only({StateAbbre={'NY'},County={'DUTCHESS','ORANGE','SULLIVAN','WESTCHESTER','PUTNAM','ROCKLAND','ULSTER'}>} CountyBoundary), CountyBoundary)

[satishkurra]

=Aggr(Only({StateAbbre={'NY'},County={'DUTCHESS','ORANGE','SULLIVAN','WESTCHESTER','PUTNAM','ROCKLAND','ULSTER'}>} County), County)

=Aggr(Only({StateAbbre={'NY'},County={'DUTCHESS','ORANGE','SULLIVAN','WESTCHESTER','PUTNAM','ROCKLAND','ULSTER'}>} CountyBoundary), CountyBoundary)

[satishkurra · Accepted solution]

Got this worked with below expression.

=Aggr(Only({StateAbbre={'NY'},County={'DUTCHESS','ORANGE','SULLIVAN','WESTCHESTER','PUTNAM','ROCKLAND','ULSTER'}>} County), County)

=Aggr(Only({StateAbbre={'NY'},County={'DUTCHESS','ORANGE','SULLIVAN','WESTCHESTER','PUTNAM','ROCKLAND','ULSTER'}>}CountyBoundary), CountyBoundary)