Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

4 Replies
GeorgeQV
Contributor III
Contributor III

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

Anonymous
Not applicable
Author

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

idogridish2
Creator III
Creator III

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

Not applicable
Author

Hi,

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