Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.. I am new to qlikview..
I am trying to create tables within a loop and here is the code:..
i have a table Categories(CategoryID,CategoryName) and a table Products(ProductID,ProductName,CategoryID) which explains why i am joining the two tables to retrieve each product and their category.
Then i want to create a table for each category and input the product names beloging to that category in the corresponding tables.
SET vCategory=' ' ;
catname:
mapping LOAD ProductName as PN,CategoryID
resident Products;
join(Categories)
LOAD CategoryID
RESIDENT Categories where exists(CategoryID);
For i=0 to NoOfRows('Categories')
vCategory = Peek('CategoryID',$(i),Categories);
NoConcatenate
For j=0 to NoOfRows('Products')-1
PRODUCT_$(vCategory):
LOAD
APPLYMAP('catname',CategoryID) as ProductName;
Next j;
Next i;
I just cannot understand what is wrong with that...i tried for a whole day.. please if you can help me out
Hello,
I don't know what you want exactly. But when i look through your script you are using wrong way of mapping concept. Through mapping concept we should match key values perfectly. For example,
map1:
mapping load * inline [
x, y
1, one
2, two
3, three ] ;
ApplyMap ('map1', 2 ) returns ' two'
ApplyMap ('map1', 4 ) returns 4
ApplyMap ('map1', 5, 'xxx') returns 'xxx'
ApplyMap ('map1', 1, 'xxx') returns 'one'
ApplyMap ('map1', 5, null( ) ) returns NULL
ApplyMap ('map1', 3, null( ) ) returns 'three'
okey...but i have a table Categories(CategoryID,CategoryName) and a table Products(ProductID,ProductName,CategoryID) and i want to create multiple tables starting with a constant like PRODUCT_<CategoryName> depending on the number of categories inside my Categories table. Then I want to fill in each table with the product which is in that category..
For example:
table PRODUCT_Baby
will have values aaa, bbb , ccc as product names
How do i go about doing this?
I didn't get what your saying, Can you elaborate little bit more. Otherwise show your two tables data with 3 or 4 rows individually and explain what you want next generating new tables i.e ( Product_1,Product_2, Product_3 ....)
Let's say i have a table Categories(CategoryID,CategoryName) and table Products(ProductID,ProductName,CategoryID)
I want to create tables like this:
I hope it is clear enough...
Hello,
Try the attached file.
Hi Jagan, I have the personal edition of Qlikview and i have exceeded the limit of 4 attempts of recoveries. So i am not able to read your qlikview file...but thank you so much for your reply.If it is not asking to much..can you post the code directly here?