topic Re: Image in Qlikview in QlikView

Image in Qlikview

Anil_Babu_Samineni — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

How to convert base64 Code into Image in QlikView.

Please Help me...

Re: Image in Qlikview

Anonymous — Tue, 21 Jun 2016 14:50:52 GMT

Hi Anil,

1.- Create a Macro function

Function OctetStringToFile(OctetString, FilePath) 
 Const adTypeText = 2
 Const adSaveCreateOverWrite = 2

 LenData = Len(OctetString)\2 + Len(OctetString) Mod 2
 set fso = createobject("scripting.filesystemobject")
 set stream = createobject("adodb.stream")
 stream.type = adTypeText
 stream.charset = "windows-1252"
 stream.open
 For i = 0 to LenData-1
  stream.writetext chr(CByte("&h" & Mid(OctetString, i*2+1, 2)))
 Next
 stream.savetofile FilePath, adSaveCreateOverWrite
 stream.close
 OctetStringToFile = "processed" 
End Function

2.- Call Function on your Script:

OctetStringToFile(YourFieldWithImage, FileOnSave) as ResultOctetStringToFile

Regards!

Re: Image in Qlikview

Anil_Babu_Samineni — Tue, 21 Jun 2016 14:54:08 GMT

PFA for Reference

In that, Go to Sheet1 and then look Image Problem

Please help me on this...

Re: Image in Qlikview

Anonymous — Tue, 21 Jun 2016 14:59:43 GMT

Hi Anil,

For the bundle images: Loading Images into QlikView

Regards!!!

Re: Image in Qlikview

Anil_Babu_Samineni — Tue, 21 Jun 2016 15:06:05 GMT

Manuel,

I already see that, And i try another way as well like File -> Export -> Export Document Layout and then i will check all XML file after getting the data.

If i take the images from Excel it will working fine.

Same as online links it is working fine. When i am fetching data from Database it showing String format because, I just convert that image to base64 and then I added that base64 string into DB and then i reload my application.

Might be one more option is there, I am not aware of that to change this base64 string into Image in qlikview?

- Anil

Re: Image in Qlikview

Anonymous — Tue, 21 Jun 2016 15:17:04 GMT

If you are getting your image in base64, the only way is my first response, create a Macro function and use it on Script.

Regards!

Re: Image in Qlikview

Anil_Babu_Samineni — Wed, 22 Jun 2016 08:08:10 GMT

Manuel,

Can you please work on my qvw as per your time frequency. Then share it to me...

Re: Image in Qlikview

Anonymous — Wed, 22 Jun 2016 09:48:35 GMT

Hi Anil,

I have tested some macros, and I cannot draw your image, please follow this post to do it. Use ODBC instead OLEDB connection.

Re: How to show the bit photo in the QlikView

Regards!

Re: Image in Qlikview

Anil_Babu_Samineni — Wed, 22 Jun 2016 09:57:55 GMT

Manuel,

Do favor for me, Can you please create one Application with Image.

1) Getting the image from Should be SQL Server?

2) And then fetch the data from Source and then create one object either Text/ Straight Table and then Send it to me. If you will get the image for UI.

3) Then let me know how do you get that, Which Macro's you are creating over there?

I Appreciate your honest help

Re: Image in Qlikview

Anonymous — Wed, 22 Jun 2016 10:04:49 GMT

Hi Anil,

I haven't any data base with images here, but on post that I have related there is an example, on this Reply. khim_hoe have showed an image from DDBB in an Straigthtable.

Regards.

Re: Image in Qlikview

Anil_Babu_Samineni — Wed, 22 Jun 2016 10:09:19 GMT

You know one thing,

I tried this. it's working fine. When i am trying to fetch the Image from SQL Server getting trouble.

In oracle / Excel / QV Objects, It is working.

Re: Image in Qlikview

Anonymous — Wed, 22 Jun 2016 10:17:36 GMT

Then, It seems a problem of SQL Server ODBC driver. I can't help you there.

Re: Image in Qlikview

Anil_Babu_Samineni — Wed, 22 Jun 2016 10:25:04 GMT

Manuel,

Sorry for troubling. Are you using SQL Server, If yes, Check your end as well. So that, We can understand easily.

Please help me for this?

If not possible, Thanks for your help for long conversation...

Re: Image in Qlikview

Anonymous — Wed, 22 Jun 2016 10:33:15 GMT

I use Oracle, MySql, SQL Server and DB2, but your problem seems to be on driver, and there I can't help you

Thanks.

Re: Image in Qlikview

Anil_Babu_Samineni — Wed, 22 Jun 2016 10:38:15 GMT

Manuel,

I am sure - Driver is not problem. Do favor me.

1) Please download one Image from Google(If Google Logo)

2) And then create one table like Image, Name( Place the Image, Google)

3) Load the data and reload ok. Then, Create one object for Qlikview to show the fields (Image, Name)

4) So, that if you will get the image then share me that qvw so that i can work here.

5) Please help me for your Valuable time?

- Anil