5 Replies Latest reply: May 5, 2017 4:04 AM by Rali Bacheva RSS

    Qlik Sense Maps - colour by selection

    Rali Bacheva

      Hello

      I'm new to Qlik and have been playing around with Qlik Maps. I have a map of all of my sales people and their customers, coloured by dimension (Sales Person name). How could I overwrite my source data, e.g. Move Customers A,B and C from Sales Person John to Sales Person Mike and have this displayed in Mike's colour on the map now?

      I've tried using the laso and bookmark but it's not ideal as I have 15 sales people and bookmark only does 1 selection at a time. Ideally I want to be able to combine multiple and be able to see what would my sales area look like if I move customers between sales people.

       

      Any suggestions would be greatly appreciated.

      Thank you

        • Re: Qlik Sense Maps - colour by selection
          victor daniel rojas

          Hello

          Doubt:

          What is your source of information (sql, txt, csv, xls ...)?

          suggestion:

            You can add a variable (s), co the extension of variables to modify that value of the variable; Install the refresh extension (refresh button) and associate the variable (s) with the vendor.

           

           

          I expect comments.

            • Re: Qlik Sense Maps - colour by selection
              Rali Bacheva

              Hi Victor, thanks for taking some time to help me

              Source info feeds from qvd - from a different qlik file then excel.

              Are you suggesting setting the Sales Person name as a variable and pass other "Sales People" names through it? How could I be able to do this multiple times without forgetting the selections I've done in the beginning. My data has thousands of customers and hundreds of sales people.

              I've attached a really small sample of my table files but this is what essentially I'm trying to achieve with the data. I've attached the example as a qvw even though my main application is in qlik sense but it's the same principle (I believe).

              Once I'm able to change the data in the table file, applying this to the map should follow

               

              Once again, thank you for your help

            • Re: Qlik Sense Maps - colour by selection
              victor daniel rojas

              Hello

              I do not quite understand the point.

              But, taking as input the fields you shared in your Qlikview App, migrate it to Sense.

              I made an app that allows you to add in a table using a variable, the records you select (clients, sellers).

              As far as I understand you, you would select certain records, associate them with a new field / value or variable and require to be stored; Well, you can do this manually in excel, but if you require it to be in Qlik, I recommend you export your table selections to excel and feed back your qlik sense App.

              I share you what I did together with the data file.

              Greetings.