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

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
Author

Hi,

Try:

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

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

perumal_41
Partner - Specialist II
Partner - Specialist II

Hi,

Try: this expression

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

Regards

Perumal A

Not applicable
Author

where i have 2 right this expression

perumal_41
Partner - Specialist II
Partner - Specialist II

Hi,

Expression Tab in Chart Properties

Regards

Perumal A

Not applicable
Author

Not working!!!!!!!!

Not applicable
Author

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

Not applicable
Author

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

perumal_41
Partner - Specialist II
Partner - Specialist II

Hi,

Please Upload ur example Application.

Regards

perumal A

Not applicable
Author

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