Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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

3 Replies

Re: Creating time-series chart with interactive table?

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.


talk is cheap, supply exceeds demand
Not applicable

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

Re: Creating time-series chart with interactive table?

Use the CrossTable function in the load script to transform the data to a more practical model

CrossTable(Person, Value)

LOAD * FROM ...source... ;

That will give you a Person dimension to make selections in.


talk is cheap, supply exceeds demand
Community Browser