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