topic Re: Re: Re: loading data ( structured with tabulation) in QlikView

loading data ( structured with tabulation)

mambi — Thu, 31 Oct 2013 09:28:03 GMT

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

Re: loading data ( structured with tabulation)

Gysbert_Wassenaar — Thu, 31 Oct 2013 12:13:12 GMT

Please post an example excel file with data.

Re: loading data ( structured with tabulation)

mambi — Thu, 31 Oct 2013 16:09:52 GMT

Hi, here is an example

Re: loading data ( structured with tabulation)

Thu, 31 Oct 2013 16:37:07 GMT

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,

Re: Re: loading data ( structured with tabulation)

Gysbert_Wassenaar — Thu, 31 Oct 2013 16:52:09 GMT

See attached example.

Re: loading data ( structured with tabulation)

Thu, 31 Oct 2013 18:49:52 GMT

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

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

mambi — Sun, 17 Nov 2013 14:03:59 GMT

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

Sport	19
football	19
France	19
Puma	19
T-SHIRT	10
Blue	10
SHOES	9
Men	9
Women	9

any idea how to do this ?