topic Re: QlikMaps: Restricting dimension values in QlikView

QlikMaps: Restricting dimension values

satishkurra — Thu, 04 Feb 2016 22:26:36 GMT

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 — Fri, 05 Feb 2016 03:15:02 GMT

Hi,

May be try like this..

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

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

jagan — Fri, 05 Feb 2016 04:01:12 GMT

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 — Fri, 05 Feb 2016 20:49:08 GMT

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 — Fri, 05 Feb 2016 21:18:17 GMT

=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 — Fri, 05 Feb 2016 21:18:48 GMT

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)