topic Re: QlikMaps: Calculated dimension, performance issue in QlikView

QlikMaps: Calculated dimension, performance issue

satishkurra — Sat, 06 Feb 2016 04:47:13 GMT

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

Re: QlikMaps: Calculated dimension, performance issue

marcus_sommer — Sat, 06 Feb 2016 07:54:05 GMT

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

Re: QlikMaps: Calculated dimension, performance issue

satishkurra — Sat, 06 Feb 2016 13:39:55 GMT

What is MapFlag here?

I mean how do i get that

Thanks

Re: QlikMaps: Calculated dimension, performance issue

marcus_sommer — Sat, 06 Feb 2016 14:07:36 GMT

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