Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
kamal_sanguri
Specialist
Specialist

Limit dimension in Map Chart

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

2 Replies
mblumenroth
Contributor II
Contributor II

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 optionUncheck this option

 

Onyi_Nwabia-Robbins
Contributor III
Contributor III

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