3 Replies Latest reply: Jun 2, 2015 6:31 AM by Gysbert Wassenaar RSS

    Creating time-series chart with interactive table?

      Hi everyone, my problem here is that I want to create a chart as shown below, but I'm not sure if it is possible. I have Date as the dimension and sales as the measure. However is there a way to link a table to the graph, such that I can select who's sales I want to show on my chart?

       

      Thank you.

      saleschart.png

        • Re: Creating time-series chart with interactive table?
          Gysbert Wassenaar

          This is standard functionality in Qlik Sense. Create your line chart with two dimensions: Date and Person. Add a Filter Pane object for the Person field. Then make selections in the Filter Pane. The line chart will show the lines for the selected Person values.

            • Re: Creating time-series chart with interactive table?

              Is this available in Qliksense Desktop? I can't seem to do that... For example my data looks something like this. I can't select Person as a dimension because it is not a column. However, Person 1, Person 2,..., etc are available as dimensions... Any suggestions?

              DatePerson 1Person 2Person 3Person 4Person 5Person 6
              Jan838,50472264,372197,1941887,822765,6942123,54596
              Feb645,68388555,1065548,2055551,9611630,1268523,45732
              Mar404,71788651,8226803,5904306,8438697,0014487,36985
              Apr979,62538594,342239,38654489,0342110,6594438,77573
              May774,85173227,223223,4495557,1086890,9817413,80793
              Jun22,390166871,5099255,5591339,043848,4476680,37373
              Jul488,68391718,2858,25331537,666322,04432400,38579
              Aug375,97751568,106582,8666192,764691,69603840,7076
              Sept174,28177347,7321350,4162442,680725,4966329,25701
              Oct750,47867662,9174457,2732569,1443920,812754,497713
              Nov56,466905257,0769163,1895373,8616316,2093327,72348
              Dec91,476516447,6803718,9597856,2071403,2652

              162,01741