topic Charts in QlikView

Charts

Wed, 21 Mar 2012 07:50:42 GMT

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??

Charts

Wed, 21 Mar 2012 08:06:00 GMT

Hi,

Try:

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

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

Charts

perumal_41 — Wed, 21 Mar 2012 08:12:38 GMT

Hi,

Try: this expression

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

Regards

Perumal A

Charts

Wed, 21 Mar 2012 08:18:47 GMT

where i have 2 right this expression

Charts

perumal_41 — Wed, 21 Mar 2012 08:20:27 GMT

Hi,

Expression Tab in Chart Properties

Regards

Perumal A

Charts

Wed, 21 Mar 2012 08:27:57 GMT

Not working!!!!!!!!

Charts

Wed, 21 Mar 2012 08:29:00 GMT

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

Charts

Wed, 21 Mar 2012 08:30:17 GMT

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

Charts

perumal_41 — Wed, 21 Mar 2012 08:30:23 GMT

Hi,

Please Upload ur example Application.

Regards

perumal A

Charts

Wed, 21 Mar 2012 08:31:47 GMT

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

Charts

kamalqlik — Wed, 21 Mar 2012 10:18:19 GMT

Hi,

Manish...this is known as Yeartodate concept in qlikview.

Go for the refrence mannual it will help you.

This is known as dynamic propert of QV and can beetter be achieved by Set analysis.

regards

Kamal