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
Johan, if you look into the table, you will find that there are 2 values: 1,0 and 0,0. So this should do the job... Correct?
shideh wrote:
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,<div></div>
Sorry, as I now there is no possibility to export the image in the standard excel-export ...
Leider, soweit ich weiss, gibt es keine Standard-Funktionalität die Bilder beim Standard-Excel-Export korrekt zu exportieren ...
Best regards
Stefan
Thanks
When i open your attached example ITILV4.qvw the field TrendVIM does not have any values, which is easily seen by making a listbox of that field, if however you have values in your example, maybe the solution could be to make the condition a numerical comparison (TrendVIM=1) instead of the string comparison (TrendVIM='1') since the latter could be dependent on how you have the field formatted.
strange, my report shows the requested values.... But anyway, the statement works....
Thnx for all efforts
kind regards
Maarten