1 Reply Latest reply: Apr 21, 2012 7:29 AM by Marko Banjanin RSS

    expression to display prior date's images

      Hi,

       

      Consider the following 2 tables

       

      Table 1

       

      Current_date

       

      Img1

       

      Img2

       

      Img3

       

      4/15/2012

       

      Blue

       

      Green

       

      Red

       

       

      Table 2

       

      Date

       

      Img1

       

      Img2

       

      Img3

       

      3/15/2012

       

      Blue

       

      Green

       

      Red

       

      2/15/2012

       

      Green

       

      Red

       

      Blue

       

      1/15/2012

       

      Red

       

      Blue

       

      Green

       

      Note: these are all built-in QV images

       

      Table 1 always keeps track of the most current month’sactivities while Table 2 keeps historic values.

       

      I need to create 2 charts. Chart 1 needs to show currentmonth’s images and chart 2 needs to display prior month’s images. Getting chart 1 to work is straightforward. I get stuckwhile writing an expression for chart 2.

       

      Based on the date selection I must also be able to selectprior dates and display images accordingly.

       

      Any suggestions?

      Thanks!