topic Re: selection year? in QlikView

selection year?

Mon, 10 Nov 2014 20:21:51 GMT

i have like

load * inline

year,sales

2000,100

2001,200

2002,300

2003,400

2004,500

2005,600

2006,700

2007,800

];

my req is 1) if click on year 2001 then i want to see the sales for 20001,2002,2003? (from current selection to 3 yers )

2) if click on year 2001 then i want to see the sales for 20002,2003,2004?(excluding current selections)

maxgro — Mon, 10 Nov 2014 20:37:24 GMT

for this

sum({$ <year={">=$(=max(year))<=$(=max(year)+2)"}>} sales)

sum({$ <year={">=$(=max(year)+1)<=$(=max(year)+3)"}>} sales)

its_anandrjs — Mon, 10 Nov 2014 21:02:06 GMT

Hi,

You can try this with the GetFieldSelections() function for get the selection values and try like

1. =sum({<year = {'>=$(=GetFieldSelections(year)) <=$(=GetFieldSelections(year)+2)'}>}sales)

2. =sum({<year = {'>=$(=GetFieldSelections(year)+1) <=$(=GetFieldSelections(year)+3)'}>}sales)

Regards

Anand

its_anandrjs — Mon, 10 Nov 2014 21:06:12 GMT

Hi,

If you use this expression for both query will be better

1. =if( GetSelectedCount(year) = 0,Sum(sales),sum({<year = {'>=$(=GetFieldSelections(year)) <=$(=GetFieldSelections(year)+2)'}>}sales))

2. =if(GetSelectedCount(year) = 0,Sum(sales),sum({<year = {'>=$(=GetFieldSelections(year)+1) <=$(=GetFieldSelections(year)+3)'}>}sales))

Regards

Anand