Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
have you set the "Representation" option to "Image"?
Best regards
Stefan
Hi Stefan,
changed Representation to Image, but I still can not see the arrows....
any other ideas???
Can you post me a sample file?
Best regards
Stefan
... have a look at the attached example ...
Best regards
Stefan
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
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.
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?
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.
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,