How to apply condition to get lost customer for the present 3 months?

[#1]

hi ,

     I have a condition that is to show dormant customers.

condition is the customers who are not available in last 3 months but available in 3 months before.

can anyone help me solve this?

advance in thanks,

[avinashelite]

could you please share some sample data

[#3]

Please find attachment for sample data ,

here i am shown two customers one customers 3gm interior must shown but other not.

[tyagishaila]

Need more information.

like which field is showing that customer is available at which time period.

for convenience, share qvw doc.

[avinashelite]

sorry currently i don't have the QV license could you please share the raw data or sample and the output format so that I would help you

[#6]

hi tyagishaila,

                    please find attachment .

i have shown 2 customer details as sample,and also I mentioned date period

fromdate as :addmonths(today(),-3)  ex:21-dec-2015

todate AS :addmonths(today(),0)  ex:21-mar-2016

I need to select the customer:>> In Between the range the customer must not have any booking_date, but the same customer have booking_date before fromdate.(21-Dec-2015)

i,e Before 21-Dec-2015 the customer have booking_date but, after 21-Dec-2015 the same customer not have any booking_date upto 21-Mar-2016.

[tyagishaila]

In attached file what is Booking_Date and CDate?

[t_chetirbok]

Hi!

See attachment.

Do you want something like this?

[tresesco]

May be like attached

Dim1: Customer

Dim2: CDate

Exp:  Only({<Customer=e({<CDate={'>$(=AddMonths(Today(),-3))'}>})>}SUBJOB_UID)

[tyagishaila]

Let me know..

if you don't get required output.

Cheers