Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

mambi
Not applicable

loading data ( structured with tabulation)

Hi every one,

i've an excel sheet with data structured like this :

Category 1
   Sub category 1
      Region 1
         Manufacturer 1
             Product 1
                 Informations 1
             Product 2
                 Informations 2

as you can see there is many levels with different tabulations

how can i load it into qlikview.?

Thanks

Tags (3)
1 Solution

Accepted Solutions
Gysbert_Wassenaar
Not applicable

Re: Re: loading data ( structured with tabulation)

See attached example.


talk is cheap, supply exceeds demand
6 Replies
Gysbert_Wassenaar
Not applicable

Re: loading data ( structured with tabulation)

Please post an example excel file with data.


talk is cheap, supply exceeds demand
mambi
Not applicable

Re: loading data ( structured with tabulation)

Hi, here is an example

Not applicable

Re: loading data ( structured with tabulation)

Hi, Mambi, please, can you explain me, what is your expected result?, with a image or a document.

if  is a simple load It will be create  two columns: column A (elements) and column B ( amount).

use  trim(columnA) for eliminate blank space.

Regards,

Gysbert_Wassenaar
Not applicable

Re: Re: loading data ( structured with tabulation)

See attached example.


talk is cheap, supply exceeds demand
Not applicable

Re: loading data ( structured with tabulation)

I like your Example. I don't know about  SET VERBATIM=1;.. thanks.

mambi
Not applicable

Re: Re: Re: loading data ( structured with tabulation)

Hi Sir,

few days ago you helped me to resolve a problem ( loading data (structured with tabulation) see above) but i have one more question please  :

as you can see in the Attached file :

for exemple : Shoes is not the sum of man + women (men and women cell's are filled by the shoes value because i haven't informations about them  ) and now i need to do calculation only on level 5 (SHOES,T-SHIRT...)  and keep level 6 on the table to get this result

Sport19
football19
France19
Puma19
T-SHIRT10
            Blue10
SHOES9
            Men9
            Women9

any idea how to do this ?