4 Replies Latest reply: Jun 1, 2017 10:08 AM by Ricky Tanna RSS

    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