set analysis?

[#1]

i have listbox year

year:

2000

2001

2002

2003

2004

2005

2006

2007

2008

1)when i click on 2002 i want sales from  2002  to    2008

2) when i click on 2004 i want sales from  2000   to 2004

3)when i click on any year and  after clearing the selections i want see sales for 2002 and 2003 ?

[PrashantSangle]

Hi,

What is logic behind it?

Can you explain in details?

Regards

[#3]

1)first one is  when i selecet any year   i want sales from that selection year to till last

2)second one is when i select  for example year  2004 i want see the sales from 2000 to 2004

3)by default i want see selection for 2003 and 2004 if i click on   2005 i want see for  2003,2004 and 2005 when i clear this selection i have to see selection for 2003 and 2004 it should not clear .

give me these three expressions

[#4]

You can't create too many types dependent selection on a single list box you can create a single based dependent selection you can follow this link to give you the desired results

http://community.qlik.com/thread/126161

[#5]

hi ra bhanu ekkadunnavu

[jyothish8807]

Better you create all three conditions seperatly and store in a variable and the call them using a button (launching a action).I hope that will work.

REgards

KC

[PrashantSangle · Accepted solution]

Hi,

1st expression Like this,

Sum({Year={">=$(=max(Year))"}}Sales)     // This will give you sum of sales from selection Month to till Last

2nd Expression Like this,

Sum({Year={"<=$(=max(Year))"}}Sales)     // This will give you sum of sales from start to current Selection Year.

Regards

[PrashantSangle]

Hi,

3rd Expression Like this,

if(getSelectedCount(Year)=0,

Sum({Year={"2003","2004"}}Sales),

Sum({Year={"2003","2004"}}Sales)+Sum({Year={"$(=max(Year))"}}Sales))

Regards