Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please post an example excel file with data.
Hi, here is an example
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,
See attached example.
I like your Example. I don't know about SET VERBATIM=1;.. thanks.
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 ?