topic Using Image in QlikView

Using Image

Thu, 19 May 2011 04:42:21 GMT

Hi,

I want to explore image in QlikView. I prepared a set of sample data, attached below.

There are 4 columns.

Device OS OS_Image_Small OS_Image_Big

Image small and image big values is the direct link of image as we can't add image on cell. So what I want is.

1 - A table, with 3 columns (except OS_Image_Big)

2 - An appropriate object where I can display OS_Image_Big column when someone select from the above mentioned table.

3 - A list of all OS_Image_Small Values as Image Representation.

I added a ListBox with Image Representation, it won't work though. So is there any way to achieve these ? In the meantime I m also figuring out how to do...

Please suggest me some way.

Thanks,

Regards,

Sachin A.

Using Image

kaushiknsolanki — Thu, 19 May 2011 06:39:52 GMT

Hi Sachin,

Can you please upload the folder with big and small imgaes..

Thanks

Kaushik Solanki

Re: Using Image

Thu, 19 May 2011 06:46:53 GMT

Sure...

I attached the QVW, XLS, Image all at one rar file. I made few things in QVW, A straight table, a listbox with image.

I want to do the following....

When I click the Small_Image in ListBox, Corresponding Big_Image will appear on the text object. So we somehow need to pass the values from listbox to that textbox. I m figuring it out how to do , if you can put some input it would be great.

Thanks.

Regards,

Sachin A.

Re: Using Image

Thu, 19 May 2011 07:06:19 GMT

Hi Sachin,

Is this what you want? (Please refer to attached zip file)

Re: Using Image

kaushiknsolanki — Thu, 19 May 2011 07:07:59 GMT

Hi Sachin

Make sure you have the images in same folder as u have mension in excel sheet.

Its working my side.

Regards,

Kaushik Solanki

Re: Using Image

kaushiknsolanki — Thu, 19 May 2011 07:13:42 GMT

Hi sachin,

I am uploading the rar Please have a look at this

Regards,

Kaushik Solanki

Re: Using Image

Thu, 19 May 2011 07:22:57 GMT

Hi Kaushik and Khim,

Sorry but today I m not in office so I don't have access to licensed version of QlikView. I m currently using Personal edition so I'll not be able to open the QVW which you guys giving. Is there any other mode to provide ?

Thanks.

Re: Using Image

Thu, 19 May 2011 07:24:53 GMT

Yes, they are. Image is working fine on my QVW. Just wanted to know how to pass the parameter from listbox to textbox object.

Listbox have small image.

TextBox have big image.

So click small in listbox, see big in textbox.

This is my current requirement.

Sorry once again, I can't open others QVW today.

Re: Using Image

Thu, 19 May 2011 07:25:41 GMT

In the text box, just change it to "=OS_Image_Big" (without the quotes)

Re: Using Image

kaushiknsolanki — Thu, 19 May 2011 07:27:34 GMT

Hi Sachin,

Do as follows,

Go to your excel file.

Change the OS_Image_Small and OS_Image_big Field value and just keep the name of the file name. Meaning remove the full path and just keep the image name with extension.

Keep the images in same folder where you have your QVW saved.

And try. I m sure this will work. As i did the same thing my side.

Regards

Kaushik Solanki

Re: Using Image

Thu, 19 May 2011 08:27:04 GMT

yes. I will do that. Absolute path is working fine either.

Thanks Kaushik and Khim.

Regards,

Sachin A.