Discussion Board for collaboration on QlikView Scripting.
Hi every one,
i've an excel sheet with data structured like this :
|Sub category 1|
as you can see there is many levels with different tabulations
how can i load it into qlikview.?
Solved! Go to Solution.
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.
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
any idea how to do this ?