Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
solved it. used aggr(only( with a variable