topic Display Sector,Industry,Company in Line Chart in QlikView

Display Sector,Industry,Company in Line Chart

Tue, 02 Nov 2010 07:14:20 GMT

Hi all

Could anyone help me

I want to display the sector,Industry and Company list in the chart using sum(GrossProfitMargin) in yearwise breakup..

I posted one sample file here..

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/0576.Line-Chart.rar:550:0]

Display Sector,Industry,Company in Line Chart

Tue, 02 Nov 2010 10:41:41 GMT

Could anyone help me..

I hope it will be clear...

Its urgent....

Let me know, whether this is possible or not....

thanks in advance...

Display Sector,Industry,Company in Line Chart

Tue, 02 Nov 2010 13:18:13 GMT

Hi,

look at the script. Now your datamodell looks better. If you like, you can go on with joining, but it is not necessary. And you can comment the redundant fields like Sector and Sectorname in the Script.

Regards

Roland


//First Table to load:
Value:
LOAD CompanyID,
 Month,
 Year,
 GrossProfitMargin
FROM
[.\test.xls]
(biff, embedded labels, table is Sheet2$);


Company:
LOAD CompanyName,
 CompanyID,
 IndustryID
FROM
test.xls
(biff, embedded labels, table is Sheet1$);

Industries:
LOAD Industries,
 Industries as Industry,
 IndustryID,
 SectorID
FROM
test.xls
(biff, embedded labels, table is Sheet4$);


Sector:
Join (Industries) // put the two tables in one together
LOAD Sector,
 Sector as SectorName,
 SectorID
FROM
test.xls
(biff, embedded labels, table is Sheet3$);


//tempSector:
//LOAD Sector as SectorName
//FROM
//test.xls
//(biff, embedded labels, table is Sheet3$);

//tempIndustries:
//LOAD Industries as Industry
//FROM
//test.xls
//(biff, embedded labels, table is Sheet4$);</body>

Display Sector,Industry,Company in Line Chart

Wed, 03 Nov 2010 05:02:23 GMT

Its necessary to show the redundant data like sector and sectorname..

Sector is having link with industries and Companies

but SectorName is not having any link...

Its used to do the comparison...

my req is to show the selecte sector,Industries and companies in the single line chart...

Could anyone help me...

thanks in advance..