topic Re: 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. in QlikView

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.

Wed, 25 Feb 2015 09:35:57 GMT

Can any one plz share the answer

Re: 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.

mukesh24 — Wed, 25 Feb 2015 09:38:33 GMT

Hi,

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

Re: 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.

oknotsen — Wed, 25 Feb 2015 09:47:05 GMT

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.

Re: 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.

Wed, 25 Feb 2015 09:48:07 GMT

Hi Mukesh,

I need expression in chart..

Re: 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.

mukesh24 — Wed, 25 Feb 2015 09:50:59 GMT

Hi,

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

Re: 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.

oknotsen — Wed, 25 Feb 2015 09:54:16 GMT

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)

Re: 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.

Wed, 25 Feb 2015 09:54:45 GMT

Yes

Re: 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.

mukesh24 — Wed, 25 Feb 2015 09:57:55 GMT

Hi Onno,

He already mention not using SET Analysis.

Re: 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.

mukesh24 — Wed, 25 Feb 2015 09:59:22 GMT

Hi RGV,

Simply change Alternate State of chart.

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

Re: 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.

Wed, 25 Feb 2015 09:59:59 GMT

Hi Onno

I need with out using set analysis

Re: 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.

d_pranskus — Wed, 25 Feb 2015 10:00:06 GMT

Use something like SUM({<Year -= {">=2007<=2011}>} Amount)

Re: 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.

Wed, 25 Feb 2015 10:02:02 GMT

Hi Darius

I need with out using set analysis

Re: 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.

d_pranskus — Wed, 25 Feb 2015 10:06:46 GMT

Why can't you use set analysis?

Re: 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.

Wed, 25 Feb 2015 10:07:46 GMT

As per my requirement i have to use only variables

Re: 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.

oknotsen — Wed, 25 Feb 2015 10:08:47 GMT

Indeed.

And I already asked why not.

Re: 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.

d_pranskus — Wed, 25 Feb 2015 10:09:46 GMT

You can use the following SUM(IF(Year >= 2007 AND Year <= 2011, Sales)).

Re: 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.

Anonymous — Wed, 25 Feb 2015 10:17:03 GMT

Hi rgv,

If you don't mind me asking,are you sure,should not use set analysis or hard code data in set analysis,instead use variables in set analysis.

Regards

Neetha

Re: 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.

neha_sri — Wed, 25 Feb 2015 10:46:49 GMT

Hi rgv,

You can use this expression.

in General>field>edit, write this expression

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

Re: 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.

Karthik3 — Wed, 25 Feb 2015 10:53:56 GMT

Can you give us one solid reason why you don't want to use set analysis?