topic Re: Setanalysis(how to retrieve data from between two values) in QlikView

Setanalysis(how to retrieve data from between two values)

Fri, 28 Feb 2014 06:00:21 GMT

Hi,

I have sales table

sales year country:

now i want sales sum of from year 1985 to 2010 ,how to write this expression setanalysis.

Thanks,

Cahganti

mahesh_agrawal — Fri, 28 Feb 2014 06:11:40 GMT

Hii,

Try the following expression

sum({$<Year={'>=1985<=2010'}>}Sale)

er_mohit — Fri, 28 Feb 2014 06:39:47 GMT

try this

Sum({<year = {">=1985<=2012"}>}sales)

or try this

sum( {<year = P({1<year={'>=1985<=2012'}>})>} sales)

Sat, 01 Mar 2014 17:35:10 GMT

this works:

sum({<year = {'>=1985<=2010'}>}sales)

see attached.

Sat, 01 Mar 2014 21:25:26 GMT

Do you need a set analysis ? These are used when we want to retrieve data that are out of scope of the selection.

sum(Sales)

choose the 15 years

that's it

if the years are in the chart, sum(total Sales) to get the total of sales (most of the time used in %)

Fabrice