topic Re: Images in Table displaying wrong in QlikView

Images in Table displaying wrong

erikzions — Tue, 07 Jun 2016 20:28:23 GMT

I have a butterfly chart in a straight table that I built with embedded images. It has broken for no reason that I can find. It is displaying the wrong image, even though it is referencing the correct one. See example below. I have bundled the images and have a formula that is dynamically selecting the correct image. (I am doing it this way because the other option of using a mini chart creates an ugly white underline when viewed in AJAX.)

I can't find anything to explain this behavior. Is there any advice out there?

I am attaching a fake dashboard with the original object at the bottom. The one I used with fake data unfortunately works with the smaller data set, so you can't see the broken example.

Re: Images in Table displaying wrong

Anonymous — Wed, 08 Jun 2016 06:44:59 GMT

Hi Erik,

Why are you using images? You can do it with Linear Gauge.

It seems that your images on QVD are wrong.

Kind regards.

Re: Images in Table displaying wrong

erikzions — Wed, 08 Jun 2016 14:47:33 GMT

I am using images because a linear gauge displays incorrectly in AJAX. In order to have the left bar extend from the right, you must invert the bar and display the background. When AJAX displays the background it puts a white border around it which destroys the illusion of the chart.

But you are correct, it is much easier with the gauge. And my images are not wrong.

Re: Images in Table displaying wrong

Anonymous — Wed, 08 Jun 2016 15:25:34 GMT

Hi Erik,

Could you share your QVD and images folder for analyze it?

Thanks!

Re: Images in Table displaying wrong

Anonymous — Wed, 08 Jun 2016 15:28:34 GMT

Hi Erik,

Viewing your expression on Var(-):

if(Dimensionality() <> 0 //Percentages are multiplied by 99 instead of 100 to try an compensate for a bug when showing the bar at 100

,if(MaxVar < 0

,'qmem://ImageID/green' & round(MaxVar * 99)

,null()//'qmem://ImageID/red0'

)

,null()//'qmem://ImageID/red0'

)

I think it will be red, not green.

Kind regards.

Re: Images in Table displaying wrong

erikzions — Wed, 08 Jun 2016 15:38:25 GMT

Here are the Images and the QVD loader. I don't think the issue is here. When I adjust the column width in my charts, the error is corrected temporarily.

Re: Images in Table displaying wrong

erikzions — Wed, 08 Jun 2016 15:39:23 GMT

I have the code commented out after the nulls. That is the only place red is mentioned. I should have removed those comments for clarity. sorry.

Re: Images in Table displaying wrong

Anonymous — Thu, 09 Jun 2016 09:51:18 GMT

Hi Erik,

It seems a bug, use Keep with Aspect, it works for me.

Kind regards