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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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