Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Charts

if the user selects the year to see the values on charts then the previous year value should get reflected.

for example if the user selects 2006 from the list box the chart should reflect the values of 2005 .

Please  help its urgent??

10 Replies
Not applicable

Charts

Hi,

Try:

Year={'$(=(max(Year)-1))'},

When we select Year=2006, The Max(Year)=2006 -> -1 -> 2005.

perumal_41
Valued Contributor II

Charts

Hi,

Try: this expression

Sum({<Year={'$(=(max(Year)-1))'}>}Value)

Regards

Perumal A

Highlighted
Not applicable

Charts

where i have 2 right this expression

perumal_41
Valued Contributor II

Charts

Hi,

Expression Tab in Chart Properties

Regards

Perumal A

Not applicable

Charts

Not working!!!!!!!!

Not applicable

Charts

Not working >>>>> can u plz give a small example

Not applicable

Charts

my years are in the list box and chart is gauge chart

perumal_41
Valued Contributor II

Charts

Hi,

Please Upload ur example Application.

Regards

perumal A

Not applicable

Charts

may be i have 2  pass the value using the variable to the chart expression ?????? m not sure