Qmem builtin functionality

[#1]

Hi,

I am having a problem with the Qmem BuiltIn functionality. While working on a dashboard, i have a column called trend which shows 2 values: 0= trend is negative and 1= positive trend. In my dashboard I want to represent a positive value (=1) with a arrow (green, upwards pointing) and if the value =0 then i want to have a red arrow pointing downwards. For this i create following statement:

=

if (TrendVIM='1', 'qmem://<bundled>/BuiltIn/arrow_ne_g.png', 'qmem://<bundled>/BuiltIn/arrow_se_r.png')

but the result is: NO DATA TO DISPLAY

Can anybody help...

thnx in advance

Maarten

[#2]

Hi,

have you set the "Representation" option to "Image"?

Best regards
Stefan

[#3]

Hi Stefan,

changed Representation to Image, but I still can not see the arrows....

any other ideas???

[#4]

Can you post me a sample file?

Best regards

Stefan

[#5 · Accepted solution]

... have a look at the attached example ...

Best regards

Stefan

[#6]

Hi Stefan,

attached you will find my prototype dashboard. The problem is in the TAB IM in the report ARROW

Hope you find the solution

Thnx in advance

Maarten

[kji]

Looks like its the "Fill with aspect" setting for the image that causes the image to be painted outside the cell, selecting "keep aspect" will give solve it.

[#8]

By adjusting the "keep aspect" a arrow is presented (thnx for this!) but it only shows red arrows pointing down, and there should be green arrows.... Any idea how to solve this?

[kji]

The TrendVIM field doesn't contain any values, so TrendVIM='1' will always be false which is why you get the red arrow, maybe this is just because you have simplified your example.

[#10]

Hi Stefan,

sorry, ich kann nicht so gut Englisch, ich habe das gleiche bei unseren Models mit Bild Funktion. Aber wenn ich die Tabelle in Excel exportiere, kommt kein Bild sondern nur das Pfad.

Gibt es die Möglichkeit diese als Bild zu exportieren.

Danke

Liebe Grüße,