Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

qlikconsultant
Contributor II

Select one value in the List-Box show 30 values in the chart.

Hi,

I want that if I select one value in the List-Box (for example Date) that are show the 10 dates before the value and 20 values after in the chart.

Any idea how i can do that?

Example:

Choosen date ist the 20.01.2012.

The chart shows the sales from 10.01.2012 to 09.02.2012.

1 Solution

Accepted Solutions

Re: Select one value in the List-Box show 30 values in the chart.

Hi,

     Use below expression in your chart.

     sum({<Date = {">=$(=date(max(Date)-10))<=$(=date(max(Date)+20))"}>}Sales)

Regards,

Kaushik Solanki    

3 Replies

Re: Select one value in the List-Box show 30 values in the chart.

Hi,

     Use below expression in your chart.

     sum({<Date = {">=$(=date(max(Date)-10))<=$(=date(max(Date)+20))"}>}Sales)

Regards,

Kaushik Solanki    

sushil353
Honored Contributor II

Re: Select one value in the List-Box show 30 values in the chart.

Hi,

Please find the attached sample

HTH

Sushil

qlikconsultant
Contributor II

Re: Select one value in the List-Box show 30 values in the chart.

How must I change the expression if  the selection is no date format?

Community Browser