QlikMaps: Calculated dimension, performance issue

[satishkurra]

Hi

I'm using the below calculated dimension in QlikMaps extension object. This expression seems to be resource heavy and taking lot of time to display the map on object selection.

Can someone help me in resolving this issue.

Note: I don't want to restrict it in back end, as i need all other data to display in other visualization.

Expression:

=Aggr(Only({State={'NewYork'},County={'DUTCHESS','ORANGE','SULLIVAN','WESTCHESTER'}>} ZipBoundary), ZipBoundary)

Thanks

Satish

[marcus_sommer]

Your expression is static - not related to selections,only fixed values - therefore I suggest (especially if you have serious performance problems) to flag this within the script so that you could use something like this:

if(MapFlag = 1, ZipBoundary)

even this will be faster then your strings within the aggr:

=Aggr(Only({MapFlag={1}>} ZipBoundary), ZipBoundary)

- Marcus

[satishkurra]

What is MapFlag here?

I mean how do i get that

Thanks

[marcus_sommer · Accepted solution]

It meant to perform a little if-loop within the load-statement, something like this:

Load

...

     if(State='NewYork' and match(County, 'DUTCHESS','ORANGE','SULLIVAN','WESTCHESTER'), 1,0) as MapFlag

...

- Marcus