Limit dimension in Map Chart

[kamal_sanguri]

Hello,

I was working with Qliksense map chart and realized the limitation option under dimension is disabled. I tried filtering data in expression itself but I was not able to suppress the Nulls/Zero.

Any idea how items in map can be reduced. My use case is I want to show the top n Profit making countries on map and don't want to show others.

Regards

Kamal

[mblumenroth]

It appears that maps cannot use calculated dimensions, but I found some decent workaround:

What I ended up doing is including the condition of the "calculated dimension" into the MEASURE itself.
Whenever it is not fulfilled set measure to zero and do not forget to uncheck "include zero values".

My measure expression was something like this:

=if(
// check if POS ID belongs to 30 topselling stores
aggr(rank(
Sum({$<[Data_Measure]={'Sales Qty (Monthly)'}>}[DM QTY])
),[Sales POS ID])<=30,
//  if yes then sum up sales qty
Num(
Sum({$<[Data_Measure]={'Sales Qty (Monthly))'}>}[DM QTY])
,'#.##0')
// else populate  zero
,0
)

Uncheck this option

[Onyi_Nwabia-Robbins]

Regarding calculated dimension on maps 

• If you make your calculated dimension a master dimension and refer to this master dimension in the 'Data ' section of the map layer.
• Then refer to your line/area/point dimension separately in the location section of the map layer

Then it works!

This seems to be memory HEAVY and performance poor for large datasets- so make sure you have enough juice on your machine to manage this. 

I use calculated dimensions to reduce the impact to the user. 

Hope this helps