Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mambi
Creator III
Creator III

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached example.


talk is cheap, supply exceeds demand

View solution in original post

6 Replies
Gysbert_Wassenaar

Please post an example excel file with data.


talk is cheap, supply exceeds demand
mambi
Creator III
Creator III
Author

Hi, here is an example

Not applicable

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

See attached example.


talk is cheap, supply exceeds demand
Not applicable

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

mambi
Creator III
Creator III
Author

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 ?