Set Analysis time interval

felcar2013 — Mon, 01 Jul 2013 09:32:15 GMT

i want to get an Expression (as in table), which is given by

sum({$<ControlGroup ={'nein'}>} Sales)/count({$<$(vSet),ControlGroup ={'nein'}>} contact_ID)

sum({$<ControlGroup ={'ja'}>} Sales)/count({$<$(vSet),ControlGroup ={'ja'}>}contact_ID)

i want to narrow the expression on a purchase_date field interval for every action, whose limits are the fields [From - To] dates. This is, Campaign A consists of Actions {A1,...., A9}, which were carried out based on the dates "From - To". The value of the expression shall adjust to the purchase_date selected.

I tried this formula, but i do not get the desired result:

sum({$<purchase_date = {">=$(From)<=$(To)"}, ControlGroup ={'nein'}>} Sales)/count({$<$(vSet),ControlGroup ={'nein'}>} contact_ID)

sum({$<purchase_date = {">=$(From)<=$(To)"},ControlGroup ={'ja'}>} Sales)/count({$<$(vSet),ControlGroup ={'ja'}>}contact_ID)

do you have any suggestions on this?

thanks

Felipe

Table summary:

Campaign	Action	From	To	Expression
A	A1	08.06.2013	30.06.2013	9.57 €
A	A2	28.05.2013	15.06.2013	5.25 €
A	A3	29.05.2013	15.06.2013	-0.97 €
A	A4	29.05.2013	15.06.2013	-2.40 €
A	A5	31.05.2013	15.06.2013	8.64 €
A	A6	31.05.2013	15.06.2013	4.46 €
A	A7	31.05.2013	15.06.2013	10.32 €
A	A8	31.05.2013	16.06.2013	6.04 €
A	A9	31.05.2013	16.06.2013	8.03 €
Total			-0.98 €

topic Set Analysis time interval in QlikView

Set Analysis time interval

Campaign

Action

From

To

Expression