Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.Join Us
=if(Sales <> 0, Cities) or if(Sum(Sales) <> 0, Cities) Where 0 is the value you don't want to include.
2. In the case where you have an 'X' symbol appear on the map after applying the above workaround, you can apply the following solution instead:
=if(<the measure/expression you want to check> <> 0 AND (not IsNull(<the measure/expression you want to check>))), <field used as location>)
=if(Sum(Sales) <> 0 AND (not IsNull(Sum(Sales))), City)
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.