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
