Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
rido1421
Contributor II

loading from excel


Hi

how would you load this data into qlikview from an excel file?

CarsBikes
CodeToyotaNissanHondaVolvoHarley davidsonHondaSuzuki
9YarisTidaballades40v1CBR1000Gsxr1000
80Aurisx-trailcivics60sevenCBR600Gsxr600
3HiluxskylineJazzD5v2FirebladeS145
1 Solution

Accepted Solutions
Not applicable

Re: Re: loading from excel

Hi,

There is no other option i think, you have to hard code something to  load this format.

Attached is example how to load this, you can further elaborate as per your usage.

7 Replies
maleksafa
Valued Contributor

Re: loading from excel

it depends how you want it to be imported, the best thing that i can think of right now it to use cross table to load this excel file.

vardhancse
Valued Contributor II

Re: loading from excel

Or y cant u ass add one more column TYPE: Cars, Bikes

So that we can load the data as normal excel sheet

rido1421
Contributor II

Re: loading from excel

Ive tried the cross table function it doesnt seem to work for my requirement

is there perhaps anything to do with the Hierarchy function?

Not applicable

Re: loading from excel

Hi,

Load twice as cross table and concatinate both table.

create dummy field type, give it value bike in one table and car in another.

Thank

Arun Goel

rido1421
Contributor II

Re: loading from excel

The data in my actual requirement is far more complex then this... I cannot edit anything on the excel spreadsheet

Not applicable

Re: Re: loading from excel

Hi,

There is no other option i think, you have to hard code something to  load this format.

Attached is example how to load this, you can further elaborate as per your usage.

rido1421
Contributor II

Re: loading from excel

Thank you much appreciated

Community Browser