Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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 |
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.