Solved: Select one value in the List-Box show 30 values in... - Qlik Community

qlikconsultant · ‎2013-03-06

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.

kaushiknsolanki · ‎2013-03-06

Hi,

Use below expression in your chart.

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

kaushiknsolanki · ‎2013-03-06

Hi,

Use below expression in your chart.

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

sushil353 · ‎2013-03-06

Hi,

Please find the attached sample

HTH

Sushil

qlikconsultant · ‎2013-03-06

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

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