Set Analysis Conditional Exclusion

Anonymous — Mon, 15 Dec 2014 12:19:27 GMT

Hi,

I have those data and I would have to exclude the rows with status = “B” when they are not in the specified date range.

For example if the date range is From: 14/12/2014 to 21/12/2014 I would have to sum the Sales for the OrdersID = 2, 3 and 4 and exclude 1 and 3. (Sum Sales = 305 € instead of 195€) How could I do it with set analysis?

LOAD * INLINE [

OrderID, Date, Status, Sales, Customer

1, '13/12/2014', 'B', 90, 'John A.'

2, '15/12/2014', 'B', 110, 'John A.'

3, '19/12/2014', 'A', 140, 'John A.'

4, '21/12/2014', 'A', 55, 'John A.'

5, '24/12/2014', 'B', 70, 'John A.'

];

Thanks in advance.

Re: Set Analysis Conditional Exclusion

lironbaram — Mon, 15 Dec 2014 12:28:25 GMT

hi have a look at the attach example

Re: Set Analysis Conditional Exclusion

Tue, 16 Dec 2014 06:19:27 GMT

I can't find attachment. thanks..

topic Set Analysis Conditional Exclusion in QlikView

Set Analysis Conditional Exclusion

Re: Set Analysis Conditional Exclusion

Re: Set Analysis Conditional Exclusion