Bundle Info for Images - Multiple attempts not working :-(

Thu, 18 Apr 2013 14:46:11 GMT

Hello!

I am very new to qv! I am on a dashboard building team to help create more visual representations of our data, and what the data means so users can see at a quick glance what needs to be on their agenda that day. We would LOVE to use pictures to display if a line of data means we're doing great, we're doing OK, we need to work on improving, we need to take drastic measures to improve, etc.

Anyway, I have spent hours on this site looking for how to use the BUNDLE and BUNDLE INFO loads. I have found a TON of information, and a lot of them end with "this works great, here's the code", however when I use that code in my application using our field and table names, etc. it doesn't work. Today is the start of day #3 on this!

Ultimately, I want to be able to say, I assume in an expression, that

if numerator/denominator >= .9 then display 'doing_great.jpg'

else if num/denom >= .7 then display 'doing_ok.jpg'

else if num/denom >= .45 then display 'needs_attention.jpg'

else display 'huge_red_flag.jpg'

Here is some code that I have tried using and haven't gotten to work. The images I want to use are stored in the same directory as this app, but under and \images folder. I have tried to use the ='qmem://...' in a text object as well, but have never gotten the expression editor/images/image folder to list anything other than the built-ins.

(please accept my apology for the following code not being in a code window. This is my first post and I cannot, for the life of me, figure out where the "advanced editor" option is!! Therefore, I can't seem to get to the "syntax highlighting" option.)

//Attempt 1
Category:
LOAD * INLINE [
Description, Photo, CategoryCount
DoingGreat,'DoingGreat.jpg',1
WereOK,'WereOK.jpg',1
Average,'Average.jpg',1
NotSoGood,'NotSoGood.jpg',1
ImmediateAttn,'ImmediateAttn.jpg',1];

Image:
BUNDLE INFO LOAD
Description,
'..\images\' & Photo
RESIDENT Category;

//Attempt 2
Category:
LOAD * Inline [
Description
DoingGreat
WereOK
Average
NotSoGood
ImmediateAttn
];

Image:
BUNDLE INFO LOAD * INLINE [
Description,
'Images\' & Description & '.jpg' as info RESIDENT Category];

//Attempt 3
Images:
BUNDLE LOAD * INLINE [
Image, File
DoingGreat,DoingGreat.jpg
WereOK,WereOK.jpg
Average,Average.jpg
NotSoGood,NotSoGood.jpg
ImmediateAttn,ImmediateAttn.jpg
];

//

PS - we are on QV 11.

Is there anything else you need to know, that I missed? Does anyone have any ideas on how I can get this to work? What am I doing wrong??

THANK YOU for any and all help!

Amy

Re: Bundle Info for Images - Multiple attempts not working :-(

GeorgeQV — Thu, 25 Feb 2016 14:53:22 GMT

I suppose, the BUNDLE LOAD statement must be the last LOAD statement in your script. Same problem caused me pain for hours!

Re: Bundle Info for Images - Multiple attempts not working :-(

Anonymous — Fri, 03 Jun 2016 15:23:15 GMT

I moved the bundle load to the end of the script and it worked too!

Re: Bundle Info for Images - Multiple attempts not working :-(

idogridish2 — Fri, 03 Jun 2016 21:10:52 GMT

hi,

may be try:

Bundle Info LOAD * INLINE [

Description, Image

DoingGreat, ..\images\DoingGreat.jpg

WereOK, ..\images\WereOK.jpg

Average, ..\images\Average.jpg

NotSoGood, ..\images\NotSoGood.jpg

ImmediateAttn,..\images\ImmediateAttn.jpg

];

Category:

LOAD * INLINE [

Description, CategoryCount

DoingGreat ,1

WereOK ,1

Average ,1

NotSoGood ,1

ImmediateAttn ,1

];

if that is not working try to hardcode the path like C:\images\DoingGreat.jpg

also see the attached.

cheers

Re: Bundle Info for Images - Multiple attempts not working :-(

Thu, 01 Jun 2017 14:08:06 GMT

Hi,

I have written a white paper on bundle loads - I hope this helps. Let me know if you have any questions. thanks

topic Bundle Info for Images - Multiple attempts not working :-( in QlikView

Bundle Info for Images - Multiple attempts not working :-(

Re: Bundle Info for Images - Multiple attempts not working :-(

Re: Bundle Info for Images - Multiple attempts not working :-(

Re: Bundle Info for Images - Multiple attempts not working :-(

Re: Bundle Info for Images - Multiple attempts not working :-(