topic Re: Showing expression as image in Qlik NPrinting

Showing expression as image

curiousfellow — Wed, 06 Mar 2024 15:09:30 GMT

In my qlikview chart I have some expressions represented as image.

When I use this chart in a Nprinting report (excel or word) the image does not show. Is there a way to achieve this ?

Re: Showing expression as image

David_Friend — Wed, 06 Mar 2024 21:01:49 GMT

Check that it doesn't contain any unsupported objects:
https://community.qlik.com/t5/Official-Support-Articles/Qlik-NPrinting-Unsupported-QlikView-Document-items-System/ta-p/1714896

Can you share some images that illustrate what is happening?

Also May 2021 has been out of support for a year now, also I imagine your are also on an old version of QlikView as well?

Re: Showing expression as image

curiousfellow — Thu, 07 Mar 2024 07:39:37 GMT

We are using Qlikview may 2021 SR1.
As the used image reside in a bundled qmem package, I think that must be the cause of not showing the images.

I am afraid I have to think of a workaround for this.

Re: Showing expression as image

Lech_Miszkiewicz — Thu, 07 Mar 2024 07:59:11 GMT

HI @curiousfellow

Yes - first thing is to make sure you meet requirements and qmem package will not work.

https://help.qlik.com/en-US/nprinting/February2024/Content/NPrinting/GettingStarted/HowCreateConnections/Connect-to-QlikView-docs.htm

Also we dont know whether you are using your QlikView object as an NPrinting Image or Level or Table?

There are many other options but they depend on how your template needs to look like and how you embed your images in it.

cheers

Re: Showing expression as image

curiousfellow — Thu, 07 Mar 2024 10:33:37 GMT

I would like to use my Qlikview chart in a Nprinting template. Embed it by the chart ifself (CH01) or by dragging the cells seperately. One of the expressions in my chart is :

if(linenumber = 60 , if (column(3) < .95 * column(2) ,'qmem://traffic_light/Red' , if (column(3) >= column(2),'qmem://traffic_light/Green','qmem://traffic_light/Yellow'))

The solution I want to try now is by adding a conditional cell to the template.

Re: Showing expression as image

Lech_Miszkiewicz — Thu, 07 Mar 2024 10:56:05 GMT

well...

in that case it will not work iwith qmem because that would be the same as "send to excel" directly from QlikView which also does not export qmem images.

anyway - you have so many other options available that there is absolutely not problem:

you can just use:

● character and conditional font formatting
or emoji characters 🔴🟡🟢
or if it is excel template you can just export values 1,2,3 and use excel based traffic lights conditional formatting
or if your traffic light does not have to be round you can just conditioanlly colour code cell background

I dont see issue here and it is only down to what is your preference...

cheers