topic Re: Extract from excel into qlikview in QlikView

Extract from excel into qlikview

nareshthavidishetty — Mon, 21 Dec 2015 11:15:32 GMT

Hi All,

Im attaching my sample excel file need to extract into qlikview but im unable to extract try to help me

Re: Extract from excel into qlikview

Mon, 21 Dec 2015 11:45:27 GMT

Hi Naresh,

can u explain a little bit more,

what is your exact requirement

Re: Extract from excel into qlikview

nareshthavidishetty — Mon, 21 Dec 2015 11:49:48 GMT

thanks for the reply actually im loading that excel data into qlikview but the format is confusing like it contains headers and some columns as u can c the sample excel sheet which i attached ,kindly help me how to do

Re: Extract from excel into qlikview

awhitfield — Mon, 21 Dec 2015 12:17:41 GMT

Looks like you would be better improving the format of your source file format, before attempting to load it into Qlikview.

Andhy

Re: Extract from excel into qlikview

nareshthavidishetty — Mon, 21 Dec 2015 12:21:47 GMT

yea because i tried to load the original data but failed to do so that's y i want some transformations or some logic which makes meaning full data so that i can load in qlikview

Re: Extract from excel into qlikview

Mon, 21 Dec 2015 13:16:17 GMT

Hi naresh,

May be this is helpful for u,

naresh:

LOAD [Name of BDO] ,

FROM

(ooxml, embedded labels, table is Sheet1);

left Join(naresh)

load [Name of BDO] as nam,

KeepChar(SubField(L,',',1),'1234567890') as [Gross Sales],

KeepChar(SubField(L,',',2),'1234567890') as free,

KeepChar(SubField(L,',',3),'1234567890') as salable,

KeepChar(SubField(L,',',4),'1234567890') as [non-salable],

KeepChar(SubField(L,',',5),'1234567890') as total

Resident naresh Where wildmatch( [Name of BDO], 'tablet*');

Re: Extract from excel into qlikview

nareshthavidishetty — Mon, 21 Dec 2015 13:49:06 GMT

actually i got the excel data like below attached one kindly have a look and help me so when im loading into qlikview its giving F11,F12,so on.....

Re: Extract from excel into qlikview

Mon, 21 Dec 2015 14:17:24 GMT

may be this is helpfull

multi_header_pivot_import.qvw

Re: Extract from excel into qlikview

nareshthavidishetty — Tue, 22 Dec 2015 05:14:25 GMT

thanks for the reply but i think its not about the pivot table what im looking is to load the data which has multiple headers kijndly have a look at the excel

Re: Extract from excel into qlikview

nareshthavidishetty — Tue, 22 Dec 2015 07:26:15 GMT

I have tried what u have sent but im unbale to load the data in qlikview

give me soem idea how to do

thanks

Re: Extract from excel into qlikview

Tue, 22 Dec 2015 09:14:51 GMT

Hi naresh,

really it is a different scenario,

how you expecting the out put.

if you can send the layout output ,then i can try any other way

Re: Extract from excel into qlikview

nareshthavidishetty — Tue, 22 Dec 2015 09:29:04 GMT

it is only the excel sheets i got like 10 excel sheets same format in which i need to load all the data into qlikview and build the dashboard thats the thing

im jus expecting how to load the data in the correct format so that i can build dashboard

Re: Extract from excel into qlikview

Peter_Cammaert — Tue, 22 Dec 2015 09:40:34 GMT

Better go back to your data sources. It's not very useful to try to load a processed layout into QlikView as you'll put a lot of energy in building a script that has to wade through complex data representations and you'll loose all the details that are letting QlikView produce spectacular analysis views. In addition to that, how much further do you think you can process data that is already aggregated?

You were saying that you tried to load the original source data, and you failed. Why was that?

Re: Extract from excel into qlikview

Tue, 22 Dec 2015 09:48:55 GMT

you want to load with group total or with out group total

Re: Extract from excel into qlikview

nareshthavidishetty — Tue, 22 Dec 2015 09:52:41 GMT

load with group total bcos there r some values present

Re: Extract from excel into qlikview

nareshthavidishetty — Tue, 22 Dec 2015 09:58:24 GMT

thanks for the reply here failed means i loaded the data and its giving me not the correct format( vague data) data even i tried to do in cross table but nothing achieved

Re: Extract from excel into qlikview

Peter_Cammaert — Tue, 22 Dec 2015 10:19:14 GMT

Those problems can be resolved (rather quickly with the assistance of the community) Moreover if it can be done in Excel, you can do it in QlikView, only better. The data transformation process that is used to produce the Excel files can be used as a guideline.

In the long run, you would be better off with loading source data and letting QlikView do what it is designed to do: present a highly accessible but powerful user interface to analyse your business data.

The choice is yours.