this is my first post as total rookie to QlikView. I got two tables like
Sales
Year
Month
Customer
Division
MatDiv1
MatDiv2
Sales amount
and
ProductHierarchy
Material
Product Family
MatDiv1 is populated only for division 1, MatDiv2 is populated only for division 2.
I want to have the material in a single column and apply apply the same lookup {(left keep (Sales) load ... from ProductHierarchy} to both Div1-Material and Div2-Material, in the script. How can I best do this?
After playing around a little bit more, it seems that the problem is with the statement
left keep (RA_raw) load ....
MatDiv1 as MatDiv
where Division = 1....
left keep (RA_raw) load ....
MatDiv2 as MatDiv
where Division <> 1....
and if I drop the left keep (RA_raw), then it doesn´t crash anymore. Now I just need to do the left keep functionality at another point in time in the script....
