2 Replies Latest reply: Jan 30, 2014 12:09 PM by Gysbert Wassenaar RSS

    Dynamic variables

      Hi there,

       

      I am trying to display our contact database through QlikView on a google map. So far, this works fine.

      All contacts have  a business segement associated e.g .Mr. Smith, Automotive, Ms. Miller, Aerospace, etc.

      How can I autmatically apply different colors to each business segement. So far I did an IF clause like

       

      if (Category='Automotive',rgb(200,0,0),rgb(0,200,0))

       

       

      How can I have Qlikview do this automatically?

       

      cheers

      Jay