1 Reply Latest reply: Oct 31, 2015 7:13 AM by Gysbert Wassenaar RSS

    Setting image on certain condition

    Ekaterina Ponkratova

      Hi All,

       

      To warn you from the beginning, I am a beginner in QlikSense.

       

      Situation: The plan was to create a dashboard/scorecard where if a quarterly value greater than a value for the proceeding quarter, the green up arrow appears, while if the value is smaller, the red down arrow appears. Below is the expression:

      if(Sum([US$ Rev, Apr 2015]) + Sum([US$ Rev, May 2015]) + Sum([US$ Rev, Jun 2015])) > (Sum([US$ Rev, Jan 2015]) + Sum([US$ Rev, Feb 2015]) + Sum([US$ Rev, Mar 2015])), 'qmem://<bundled>/Green_Up.png','qmem://<bundled>/BuiltIn/Red_Down.png').

       

      You can see from the screenshot below that I added images to the media library.

      1.png

       

      Problem: Instead of the image, the string qmem://<bundled>/Green_Up.png is displayed. Any suggestion what the problem is?

       

      Regards,

       

      Eka