topic Re: Set analysis in QlikView

Set analysis

Wed, 13 Nov 2013 17:22:20 GMT

Hi all,

Table 1:

id orderdate sales year

1 01/02/2001 100 2001

2 01/02/2002 200 2002

3 01/02/2003 300 2003

4 01/02/2004 400 2004

Now i want load only "01/02/2003" below data.

I want write this filter condition in set analysis expression and filter must be a variable.

Regards

Suresh

Re: Set analysis

rustyfishbones — Wed, 13 Nov 2013 17:25:14 GMT

so add a WHERE statement at the end

Table 1:

id orderdate sales year

1 01/02/2001 100 2001

2 01/02/2002 200 2002

3 01/02/2003 300 2003

4 01/02/2004 400 2004

WHERE orderdate = '01/02/2003';

Re: Set analysis

israrkhan — Wed, 13 Nov 2013 17:28:22 GMT

try below in set analysis:

sum({1<orderdate = {">= 01/02/2003 "}>} sales)

Re: Set analysis

Wed, 13 Nov 2013 17:32:13 GMT

Thank you for your reply,

ex: let vdatefilter=makedate(2003,02,01);

then use this variable in SetAnalysis as a filter

I want write filter condition in SetAnalysis and filter must be a variable

Regards

Suresh

Re: Set analysis

MayilVahanan — Wed, 13 Nov 2013 17:33:52 GMT

Try like this

Now i want load only "01/02/2003" below data:

= sum({1<orderdate = {"<01/02/2003"}>} sales)

Edit:

PFA

Note:

If you need to load only data upto "01/02/2003", then you can go with Allan

Re: Set analysis

Wed, 13 Nov 2013 17:35:44 GMT

Why SET Analysis? the solution from Alan Ferrel is correct!!! and more sample!!

Re: Set analysis

Wed, 13 Nov 2013 18:01:25 GMT

=sum({$<OrderDate={"<=$(datefilter)"}>} Sales)