data loading

[#1]

Thanking you

Josna

[svenkita]

Loading Excel Data into QlikView

Check this out

[#3]

please once check  the data subharaman I know how to import the data excel to qv .

[Anonymous]

Hi,

Do you want to display a chart as in the attachment ?

[svenkita]

Try This out

[arulsettu]

post sample app

[#7]

Country	Afghanistan
YEAR	2012-13		2013-14		2014-15
Product	Qty	Value	Qty	Value	Qty	Value
Buffalo Meat	905.4	966.97	1,467.60	1,681.09	2,982.90	3,842.12
Poultry Products	1,83,247.23	7,816.36	99,067.20	4,215.10	77,137.28	2,665.61
Dairy Products	1,076.73	1,798.20	1,133.40	2,275.24	689.36	1,600.92
Other Processed Fruits & Vegetables	77.59	66.29	117.24	195.38	663.96	1,335.65
Miscellaneous Preparations	115.65	178.33	124.23	242.89	173.4	1,158.30
Wheat	32,499.80	6,431.75	1,14,737.50	22,709.03	2,750.00	544.23
Basmati Rice	1,553.00	805.92	48	29.48	258	158.17
Cereal Preparations	141.56	90.64	176.37	126.57	121.45	155.25	S
Fruits & Vegetables Seeds	1.87	19.73	0.03	6.48	22.34	44.13
Jaggery & Confectionery	16.2	14.52	15.63	30.96	22.22	26.17
Groundnuts	0	0	0	0	37.5	21.6
Fresh Grapes	0	0	0	0	20	17.47
Other Fresh Fruits	215.5	50.7	21.17	9.03	16.41	7
Floriculture	7.35	11.21	3.64	4.17	4.32	6.13
Other Fresh Vegetables	82.45	26.85	29	13.21	5.13	2.39
Non Basmati Rice	72	29.73	0	0	6	1.16
Guargum	0	0	90.01	341.47	0	0
Mango Pulp	20.97	6.74	0	0	0	0
Fresh Mangoes	8.35	4	1.53	2.05	0	0
Fresh Onions	5.45	0.36	1.31	0.43	0	0
Dried & Preserved Vegetables	0.65	121.81	0.07	13.27	0	0
Sheep/Goat Meat	0.7	2.27	0	0	0	0

[settu_periasamy]

Hi,

Check the below link from Gysbert. Load the table with Multiheader..

multi_header_pivot_import.qvw

[settu_periasamy]

Hi,

Not sure this one you need.

may be like this, if we have data like the below

Need to do with cross table.

Directory;
CrossTable(Year, Data, 3)
LOAD country, 
     Year as Year1, 
     Product, 
     abcd, 
     egh, 
     ijkl, 
     mnop
FROM
[check_cross.xls]
(biff, embedded labels, table is Sheet1$, filters(
Replace(2, right, StrCnd(null)),
Transpose(),
Replace(1, top, StrCnd(null)),
Replace(2, top, StrCnd(null))
));

[#10]

No its not working