Line Chart setting dimension - Help Required

[#1]

Hi.

I hope there is a very simple solution to this! I attach an xls output that shows what I require and the inline statement to load into a qv file. In essence the x-axis dimension should comprise of each of the individual domains (dom1, dom2, etc). The dimensions field however seems to crave a single field rather than each of the 5 different domains.

ChartData:

Load * Inline [

ClientNo,TestDate,Dom1,Dom2,Dom3,Dom4,Dom5

36251, 13/05/2010, 21, 25, 15, 29, 28

36252, 14/05/2010, 12, 15, 18, 21, 25

36252, 15/08/2010, 25, 30, 31, 32, 28

36251, 17/08/2010, 21, 27, 25, 35, 32

36253, 21/11/2010, 10, 15, 17, 22, 15

36251, 21/11/2010, 33, 40, 42, 45, 45];

Many thanks Neil

Any help hugely appreciated!

[#2 · Accepted solution]

Hi Yenridla,

Please use the below code to achive your chart in QlikView .

ChartData1:
CrossTable(Dim,DimData,2)
LOAD Client_Number,
Date_Test,
Dom1,
Dom2,
Dom3,
Dom4,
Dom5
FROM
(ooxml, embedded labels, table is Sheet3);
ChartData:
Load *,
'1' as Junk
resident ChartData1;
drop table ChartData1; Use Dim & Date_Test as the dimensions and Sum(DimData) in the expression . You can specify your naming conventions in place of in place of Dim & DimData in the cross table function. Regards, Chakravarthy.

[#3]

Hi and many thanks Chakravarthy. This does work and is one of those where I don't know how I would have stumbled upon the right code by myself! Have a project to work on and am keen to solicit someone that might be able to help out. This would be on an ad-hok basis for a fee agreeable to both parties. If interested then contact me on neilh@qualasys.com

Thanks Neil