Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
could you please share some sample data
Please find attachment for sample data ,
here i am shown two customers one customers 3gm interior must shown but other not.
Need more information.
like which field is showing that customer is available at which time period.
for convenience, share qvw doc.
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
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.
In attached file what is Booking_Date and CDate?
Hi!
See attachment.
Do you want something like this?
May be like attached
Dim1: Customer
Dim2: CDate
Exp: Only({<Customer=e({<CDate={'>$(=AddMonths(Today(),-3))'}>})>}SUBJOB_UID)
Let me know..
if you don't get required output.
Cheers