I have taken YEAR field in list box,it is having 2004 to 2014 sales.But i need 2007 to 2011 sales with out using set analysis.

[#1]

Can any one plz share the answer

[mukesh24]

Hi,

U need to restrict data in Listbox or want expression in CHart?

[oknotsen]

Make a listbox for Year and select the years 2007 to 2011. This will make all charts in your application respond to this filter and only show related data.

If that does not solve your problem, please clarify what you are trying to achieve.

[#4]

Hi Mukesh,

     I need expression in chart..

[mukesh24]

Hi,

If u select any value from listbox then also u want result from 2007 to 2011?

[oknotsen]

So you do not want to filter using a listbox.

Is there a specific reason why you do not want to use Set Analysis as it sounds to me as the easy solution.

Example:

sum({ < Year = {2007, 2008, 2009, 2010, 2011} > } Sales)

[#7]

Yes

[mukesh24]

Hi Onno,

He already mention not using SET Analysis.

[mukesh24]

Hi RGV,

  Simply change Alternate State of chart.

  SO when u select any value from list box it will not affect to chart.

[#10]

Hi Onno

   I need with out using set analysis