Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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

 

Highlighted
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