0 Replies Latest reply: Jan 19, 2016 4:07 PM by Ashalatha Devathi RSS

    Maps in Qlikview/Qlik Sense

    Ashalatha Devathi

      Hi All, I am trying to create a map exactly like below, Please let me know your thoughts:

       

      http://lwd.dol.state.nj.us/labor/lpa/industry/incpov/income.pdf

       

      I just did the following steps in Qlik sense:

       

      1.Downloaded the KML file from Cartographic Boundary KML Files - County Subdivisions - Geography - U.S. Census Bureau for New Jersey and renamed cb_2014_34_cousub_500k.Name as Municipality.

      2. Loaded the  attached Excel sheet with Municipality data.

      3. Created Map with Municipality as a dimention

      4.Added Sum(Per ca-pita Income) as a measure.

       

      Now, I am having issue with adding colors by Expression, I need range for colors

       

      For Eg If Sum([cb_2014_34_cousub_500k.Area]) between 0 and 35,000 then Red

       

      Please advise me on this.