topic Qmem builtin functionality in QlikView

Qmem builtin functionality

Fri, 09 Oct 2009 15:20:11 GMT

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

Qmem builtin functionality

Fri, 09 Oct 2009 15:44:21 GMT

Hi,

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

Best regards
Stefan

Qmem builtin functionality

Fri, 09 Oct 2009 15:55:19 GMT

Hi Stefan,

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

any other ideas???

Qmem builtin functionality

Fri, 09 Oct 2009 16:57:51 GMT

Can you post me a sample file?

Best regards

Stefan

Qmem builtin functionality

Fri, 09 Oct 2009 17:05:22 GMT

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

Best regards

Stefan

Qmem builtin functionality

Fri, 09 Oct 2009 17:07:42 GMT

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

Qmem builtin functionality

kji — Fri, 09 Oct 2009 17:32:35 GMT

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.

Qmem builtin functionality

Fri, 09 Oct 2009 18:09:33 GMT

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?

Qmem builtin functionality

kji — Fri, 09 Oct 2009 18:29:07 GMT

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.

Qmem builtin functionality

Fri, 09 Oct 2009 18:59:32 GMT

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,

Qmem builtin functionality

Fri, 09 Oct 2009 19:00:49 GMT

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?

Qmem builtin functionality

Fri, 09 Oct 2009 19:07:27 GMT


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

Qmem builtin functionality

Fri, 09 Oct 2009 19:10:23 GMT

Thanks

Qmem builtin functionality

kji — Fri, 09 Oct 2009 19:11:34 GMT

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.

Qmem builtin functionality

Fri, 09 Oct 2009 19:16:41 GMT

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

Thnx for all efforts

kind regards

Maarten