Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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!

1 Reply
Not applicable
Author

solved it. used aggr(only( with a variable