Set Analysis OR

avastani — Thu, 27 Jun 2013 02:06:24 GMT

What would the set analysis expression in COUNT(OrderLineID) be for those values where Date1 OR Date2 have the same Month Year and Month Year is determined using Date2

Sample Data

Date1, Date2, OrderLineID, Amt, Qty

3/4/2013, 4/1/2013, 1, 3409, 34

4/5/2013, 4/6/2013, 2, 56, 1

4/20/2013, 5/1/2013, 3, 49, 3

2/1/2011, 3/31/2013, 4, 5959, 2

the result in the above data set should be 3 when the X-axis uses Month(Date2) for time series

any ideas? I think an OR in set analysis is needed.

Re: Set Analysis OR

avastani — Thu, 27 Jun 2013 03:16:37 GMT

I am thinking I will probably not be able to solve this problem unless I introduce a neutral third date Date3 which does the summary of this metric in script and supports it as high dimensional levels than OrderLine and Orders

topic Re: Set Analysis OR in QlikView

Set Analysis OR

Re: Set Analysis OR