Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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!