topic Re: data loading in QlikView

data loading

Thu, 03 Sep 2015 06:28:44 GMT

Thanking you

Josna

Re: data loading

svenkita — Thu, 03 Sep 2015 06:43:21 GMT

Loading Excel Data into QlikView

Check this out

Re: data loading

Thu, 03 Sep 2015 06:46:23 GMT

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

Re: data loading

Anonymous — Thu, 03 Sep 2015 06:54:58 GMT

Hi,

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

Re: data loading

svenkita — Thu, 03 Sep 2015 06:55:21 GMT

Try This out

Re: data loading

arulsettu — Thu, 03 Sep 2015 06:55:40 GMT

post sample app

Re: data loading

Thu, 03 Sep 2015 06:57:21 GMT

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

Re: data loading

settu_periasamy — Thu, 03 Sep 2015 07:11:54 GMT

Hi,

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

multi_header_pivot_import.qvw

Re: data loading

settu_periasamy — Thu, 03 Sep 2015 07:31:01 GMT

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))
));

Re: data loading

Thu, 03 Sep 2015 07:49:46 GMT

No its not working

Re: data loading

settu_periasamy — Thu, 03 Sep 2015 08:00:04 GMT

Not working means, Qlikview is not loading or have you get any error?

Re: data loading

Thu, 03 Sep 2015 08:39:01 GMT

It will this type Settu

Thanks

Joshna

Re: data loading

settu_periasamy — Thu, 03 Sep 2015 08:56:55 GMT

Is it posssible to provide the data in excel format?

Re: data loading

svenkita — Thu, 03 Sep 2015 09:00:52 GMT

Hi Josna,

Following is the output

there are multiple stages of loading, have a look at the script you will understand.

also attaching the qvw and the excel file

hope this helps

Re: data loading

svenkita — Thu, 03 Sep 2015 09:16:49 GMT

This would be One more alternate Solution