Solved: Re: I have taken YEAR field in list box,it is havi... - Qlik Community

Report Inappropriate Content · ‎2015-02-25

Can any one plz share the answer

neha_sri · ‎2015-02-25

Hi rgv,

You can use this expression.

in General>field>edit, write this expression

if(Year>=2007 and Year<=2011,Sale) . It will work

View solution in original post

mukesh24 · ‎2015-02-25

Hi,

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

oknotsen · ‎2015-02-25

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.

May you live in interesting times!

Report Inappropriate Content · ‎2015-02-25

Hi Mukesh,

I need expression in chart..

mukesh24 · ‎2015-02-25

Hi,

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

oknotsen · ‎2015-02-25

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)

May you live in interesting times!

Report Inappropriate Content · ‎2015-02-25

Yes

mukesh24 · ‎2015-02-25

Hi Onno,

He already mention not using SET Analysis.

mukesh24 · ‎2015-02-25

Hi RGV,

Simply change Alternate State of chart.

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

Report Inappropriate Content · ‎2015-02-25

Hi Onno

I need with out using set analysis

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.