Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Displaying more than one image per row.

Hi,

I am having problems displaying more than on image per row. I know how to use the info() function and display one image.

The field in the table are similar to this: SessionID , BeforeImage, BeforeImageZoomed, AfterImage, AfterImageZoomed.

How to I display all of those image at the same time all linked to the SessionID?

Please note that that the images are actually stored in the database.

Thanks in advance.

8 Replies
Not applicable
Author

hi,

you can use a straight table to display more than one image per row and use representation as image in the expressions tab of your chart properties dialogue

thanks

Not applicable
Author

That is one of the first things I tried, did not work. Maybe I am doing it wrong.

Anyway, I need to use textboxes.

I can get one of the images to display using the usual "info sql select...." and then using "=info(SessionID)" in the textbox with image as presentation.

But that is not what I need, I need to display all four images.

Thanks

Not applicable
Author

Ok I have tried a couple of ideas with one of two outcomes. Either only one image displays or the images are not linked to one another.

Surely there must be a way to display more than one image per row from a table.

Not applicable
Author

hi,

can u pls attach your application here

thanks

Not applicable
Author

I figured it out.

ImageTable consists of MD_SessionID, Image1, Image2, Image3, Image4.

SQL SELECT

"MD_SessionID",

MD_SessionID as SessionID1,

MD_SessionID as SessionID2,

MD_SessionID as SessionID3,

MD_SessionID as SessionID4

FROM Database001.dbo.ImageTable;




info SQL SELECT

MD_SessionID as SessionID1,

"Image1"

FROM Database001.dbo.ImageTable;



info SQL SELECT

MD_SessionID as SessionID2,

"Image2"

FROM Database001.dbo.ImageTable;


info SQL SELECT

MD_SessionID as SessionID3,

"Image3"

FROM Database001.dbo.ImageTable;


info SQL SELECT

MD_SessionID as SessionID4,

"Image4"

FROM Database001.dbo.ImageTable;

This works, but maybe someone has a better way of doing it?

prabhu0505
Specialist
Specialist

Hi DieterZA

I tried map the images from database using the above method but I'm getting the following error for the field in the straight table.

qmem://<9>/<0>

Not applicable
Author

hi Saravana,

its not an error

you should set representation as image in your expressions tab of chart properties dialogue

thanks

prabhu0505
Specialist
Specialist

Hi tauqueer,

Thanks for your interest.

In my expression tab for the straight table, representation was set to image only.