Creating time-series chart with interactive table?

[#1]

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.

[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.

[#3]

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?

Date	Person 1	Person 2	Person 3	Person 4	Person 5	Person 6
Jan	838,50472	264,372	197,1941	887,822	765,6942	123,54596
Feb	645,68388	555,1065	548,2055	551,9611	630,1268	523,45732
Mar	404,71788	651,8226	803,5904	306,8438	697,0014	487,36985
Apr	979,62538	594,3422	39,38654	489,0342	110,6594	438,77573
May	774,85173	227,223	223,4495	557,1086	890,9817	413,80793
Jun	22,390166	871,5099	255,5591	339,043	848,4476	680,37373
Jul	488,68391	718,28	58,25331	537,6663	22,04432	400,38579
Aug	375,97751	568,1065	82,8666	192,7646	91,69603	840,7076
Sept	174,28177	347,7321	350,4162	442,6807	25,4966	329,25701
Oct	750,47867	662,9174	457,2732	569,1443	920,8127	54,497713
Nov	56,466905	257,0769	163,1895	373,8616	316,2093	327,72348
Dec	91,476516	447,6803	718,9597	856,2071	403,2652	162,01741

[Gysbert_Wassenaar]

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.