Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
leozilio
Contributor
Contributor

Linked images on Sense

Hi there,

I am trying to link images with one of my dimensions: acctually I have a dimension of names and for each name I have a .jpg file. I would like to display the image (picture) into a "Text and Image" graph when the respective name was selected in a parallel table.

Does any one knows how can I do it?

Thanks

16 Replies
yasmeenk
Partner - Creator
Partner - Creator

Yeah Zilio,

Can you share the sample qvf file to work on?

leozilio
Contributor
Contributor
Author

Yasmeen: it works!!!!!

I don't know how, but now the picture is visible at the table!

Have another problem now: I would like that for each name (PARLAMENTAR) just one picture was showed...

I don't think I am able to send the .qvf file (I have no option to attach files; only images, videos or links)... maybe because my Qlik Desktop version??

But here it is all my Script, and below, the Table's result with double image been showed:

[Congressista]:

LOAD [PARLAMENTAR],

  [MANDATO],

  [PARTIDO],

  [UF]

FROM [lib://Qlik temp/Congressista.xlsx]

(ooxml, embedded labels, table is Congressista);

[Filtro]:

LOAD [PARLAMENTAR],

  [R$],

  [PF/PJ],

  [CPF/CNPJ],

  [DOADOR]

FROM [lib://Qlik temp/Doacao.xlsx]

(ooxml, embedded labels, table is Filtro);

Images:

Load * INLINE [

    Image, Image Location

    Qlik Local Image, http://localhost:4848/content/default/Beto Mansur.jpg,

    Qlik Local Image, http://localhost:4848/content/default/Adail Carneiro.jpg

];

Table in double.png

yasmeenk
Partner - Creator
Partner - Creator

Sounds good.

Can you try by changing the Image names as per "PARLAMENTAR" i.e.,


Images:

Load * INLINE [

    Image, Image Location

   Beto Mansur , http://localhost:4848/content/default/Beto Mansur.jpg,

    Adail Carneiro, http://localhost:4848/content/default/Adail Carneiro.jpg

];

leozilio
Contributor
Contributor
Author

I understand Yasmeen,

I already tried this, but the problem stays the same.

I also realized than:

- If the Table has the dimensions "PARLAMENTAR" and "Image Location", what happens is like a double counting: each PARLAMENTAR appears with its respective image plus anothes PARLAMENTAR's images

- If the Table has the dimensions "Image" and "Image Location", it works well, i.e., for each name I have the correct image.

Unfortunantely I need a correspondence between PARLAMENTAR's names and Image Location... maybe I am doing something wrong on this issue...

yasmeenk
Partner - Creator
Partner - Creator

Can you try by changing the inline field name as per the original field?

Like below,

Images:

Load * INLINE [

    PARLAMENTAR, Image Location

   Beto Mansur , http://localhost:4848/content/default/Beto Mansur.jpg,

    Adail Carneiro, http://localhost:4848/content/default/Adail Carneiro.jpg

];

It's just a guess

leozilio
Contributor
Contributor
Author

Now I think it's PERFECT!

I'll exercise a little bit more, but I really think it works as I needed.

Thank you very much!

yasmeenk
Partner - Creator
Partner - Creator

Glad that it helps!