Question re Calculated DIMENSION

jduenyas — Tue, 27 Mar 2012 20:14:42 GMT

Hi All

I have a table like the following:

Customer	Customer CreateDate	Order CreateDate	Order Amount
A	1/1/11	1/1/12	125.00
B	1/1/12	1/15/12	352.00
A	1/1/11	2/1/12	35.00
C	2/1/12	2/15/12	486.00
A	1/1/11	2/15/12	651.00
B	1/1/12	3/1/12	268.00
D	2/1/12	3/1/12	566.00
E	2/1/12	3/15/12	321.00
D	2/1/12	3/15/12	951.00
F	3/15/12	3/15/12	423.00

I wish to show total of orders by selecting Order Date but only of the customers whose create date is equal or greater then the minimum order date.

So if selecting order date as greater than or equal Feb (2/1/12), Customer A and B will not show because they were create prior to the date selected. Likewise if selecting order dates greater than or equal Mar (3/1/12) only Customer F will show.

I want the Customer to be in the DIMENSION list and the total calcultaed in the Expression.

In other words, I wish to show in my table only the NEW Customers who palced an order in the selected range of the order dates.

I tried to set the dimension to be:

If([Customer CreateDate] >= [Order CreateDate],Customer) but that did not work.

Any ideas?

Thanks

Josh

Question re Calculated DIMENSION

pover — Tue, 27 Mar 2012 21:20:38 GMT

Josh,

Try creating a variable called vMinOrderDate that is

=min([Order CreateDate])

Then create a calculated dimension that is

=if([Customer CreateDate] >= vMinOrderDate, Customer)

Then enable the suppress null values option for that field.

Karl

Question re Calculated DIMENSION

jduenyas — Tue, 27 Mar 2012 21:29:06 GMT

You are a genius Karl.

Thanks. It worked.

topic Question re Calculated DIMENSION in QlikView

Question re Calculated DIMENSION

Question re Calculated DIMENSION

Question re Calculated DIMENSION