topic Re: set analysis? in QlikView

set analysis?

Mon, 22 Sep 2014 11:06:30 GMT

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 ?

Re: set analysis?

PrashantSangle — Mon, 22 Sep 2014 11:11:06 GMT

Hi,

What is logic behind it?

Can you explain in details?

Regards

Re: set analysis?

Mon, 22 Sep 2014 11:16:54 GMT

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

Re: set analysis?

Mon, 22 Sep 2014 11:21:02 GMT

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

Re: set analysis?

Mon, 22 Sep 2014 11:27:33 GMT

hi ra bhanu ekkadunnavu

Re: set analysis?

jyothish8807 — Mon, 22 Sep 2014 11:28:36 GMT

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

Re: set analysis?

PrashantSangle — Mon, 22 Sep 2014 11:50:10 GMT

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

Re: set analysis?

PrashantSangle — Mon, 22 Sep 2014 11:55:00 GMT

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