Discussion Board for collaboration related to QlikView App Development.
I am having a really issue here
In my sql database i have Product and Product Image columns
I want to Load the product code with the images in Qlikview, I have tried Bundle Info Load but it didn't work.
I created a table with the Product codes and the product images as expression with selecting Image in the representation drop down list but with no success as well
The Product code and last part of the image link are similar such as;
Product Code Product Image
I have tested on this image https://www.analyticsvidhya.com/blog/wp-content/uploads/2015/01/Qlikview.jpg still didn't work.
I am trying to avoid using Inline (if I have to list all the product codes and product images) as I have a very big list 5000+ products/images
Would you please be able to help?
How you create the Bundle Load in script from Qlikview. Can you show the script and that please show the image of object which you used
Amir - take a look at my solution. My issue was that Images were stored in the local dir and I had to create URL link to map to those images. Database only included path to those images
Convert File Path into URL Link
also, had to add script to the load editor to create
"Image_Dir", // Image Path
"Images"; // Image Name
// Break Images field into multiple fields -------- all my images were stored under the same value for each product (e.g, "Image1.jpg; Image2.jpg; Image3.jpg; ...."
for y=1 to 100
CROSSTABLE(ImageId, ImageName, 1)
subfield(Images,';',$(y)) as Image$(y)
DROP TABLE Images;
where ImageName like upper('*.JPG*');
DROP TABLE ImagesTemp;
see attached qvw
hope this helps
Even Frank's linked qvw is displaying as a link for me.
Does anyone have any clue what's going wrong for me ?
(I have checked the .ini file in my settings and tried options 1 & 2 for the "AllowGeneralAccessToImagesThroughURL=" setting.