Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please see the attached QVW file, where i am trying to add some images.
Req,test and defect values has specific images and i want to attach these specific images to specific data.
In attached QVW file only one (wrong) image is displayed for defect.
How can all images with correct data can be displayed?
Thanks in advance
Hi Mansi,
Your QVW show only one image is loaded, please check you source file, or upload it for all to help.
regards,
Hello
You need to change your expression for the Image to =Info(Tab), when I did this it gave me blank lines rather than an expression in the cells but I'm not sure if this means the images are not there.
Just for your peace of mind I have attached the same sort of thing that certainly works for me, as you'll see from the currency symbols on the table.
Hope it helps,
Thanks QVCON for the reply.
This the problem that it is displaying one image only.
Do you want me to send other image and data file?
Thanks
Thanks Nigel.
It is showing same blank line at my end even after attaching the images.
I am showing you the data file format which i am using:
ImageTest1.txt
Tab,I
Req,req.JPEG
Test,testing.JPEG
Defect,defect.gif
Please let me know if problem is in this data file.
Hi
Can you attach the ImageTest1.TXT file please.
Sure Nigel.
Attached is ImageTest1.TXT file.
Hello Mansi!
I have seen you document but not able to understand what you are doing there. Why don't you use the below expression to display the image.
<pre>if(Sum(SalValue) - before(Sum(SalValue)) < 0,'F:\Red.png', if(Sum(SalValue) - before(Sum(SalValue)) > 0, 'F:\Green.png','F:\Blue.png'))
// Refer http://community.qlik.com/forums/t/24170.aspx
Thanks and Regards,
Rikab
Hi Mansi
Having read the thread above, this seems like a better solution for your problem, I didn't think you could access images straight from the folders so I suggest using that solution.
One thing that I can't remember is whether I used PNG files because JPG files would not work, my solution works using PNG files and the thread above uses PNG files also, so you might want to try changing to PNG rather than JPG.
Good luck,
use the following code in the editscript dialogue of your qvw file
image:
LOAD Tab,
I,
rowno() as no
FROM
.....\imagetest1.txt
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
let vNo = peek('no',-1,'image'); // Get current number of image from image table field
for i=1 to $(vNo) // Go to the current number of image
Photos:
load $(i) as no, $(i)&'_150.jpg' as Photo autogenerate(1);
next
for j=1 to $(vNo)
BUNDLE INFO LOAD * INLINE [
Photo, Index
$(j)_150.jpg, .....(here u write the path of the folder where you will be keeping your images)\$(j)_150.jpg
];
next j;
[\code]
you also need to rename your image req as 1_150, testing as 2_150 and so on as per the requirement of above code.
one constraint in the above code is that you can only open either all jpg images in your image folder at onetime or all gif images or all png images or all bmp and so on. ie the type of image should be same.
thanks
</body>