Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MVP & Luminary
MVP & Luminary

See attached example.


talk is cheap, supply exceeds demand

View solution in original post

6 Replies
MVP & Luminary
MVP & Luminary

Please post an example excel file with data.


talk is cheap, supply exceeds demand
Creator III
Creator III

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,

MVP & Luminary
MVP & Luminary

See attached example.


talk is cheap, supply exceeds demand

View solution in original post

Not applicable

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

Creator III
Creator III

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 ?