Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qmem builtin functionality

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

14 Replies
Not applicable
Author

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?

Not applicable
Author


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

Not applicable
Author

Thanks

kji
Employee
Employee

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.

Not applicable
Author

strange, my report shows the requested values.... But anyway, the statement works....

Thnx for all efforts

kind regards

Maarten