Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
zhujason858_cha
New Contributor II

How to show null Qlik map dimensions

I have a Qlik heat map made up of multiple counties in Kenya. Some of these counties do not have any data associated with them. When no year is selected (image on the left), all the counties appear. When one of the years (or any of them) is selected then the counties with no associated data (in grey) disappear. I would like all the counties to always show, even if there is not associated data.

I tried toggling the "Include null values" of my dimension but that doesn't fix anything. Any help would be greatly appreciated.

Qlik Help Image.png

Best,
Jason

Tags (1)
1 Reply
YoussefBelloum
Esteemed Contributor

Re: How to show null Qlik map dimensions

Hi,

unfortunately Map object completely change on the latest version of the Cloud..

try multiplying your color expression by sum(1)

example:

=YOUR_EXPRESSION*Sum(1)