I know this topic it posted more than 3 time but I check all of it nothing similar to this.
My case is ; I need to get the new Customer where is in variable changed based on the variable to change .
I have to QVD one for Orders and the other for the customer data, the order qvd it contain all details for the order data with column called SHIFT_DATE this column store all date for the daily orders and also this column I use it as my master calendar and my primary key in the order view is my Cust_phone_number containing the customer phone number joined with the customer view, and inside the customer view there is a CREATION_DATE this will store the date for customer in the first time in my DB; so my scenario is :
If I need to know the new customer in specific period based in the selection to count the customer phone number where the creation date >= the current selection.
If I need to know the new customer by using the variable in input box once I enter the date that I need it will search only all new customer that > my input date.
I try to use variable and set analysis but every time gave me wrong data or errors in the set analysis,
what i did in my original application on one of the things to get the new and old customer is :
1. i create a variable to get the new customer before 3 month the variable was =Max(CREATION_DATE)-90 to get 3 month back but when i validate the numbers with my database it was incorrect and it dose not work if i select specific month; what i want is if i select specific month it will retrieve the number of the new customer in text box (it will check if the CREATION_DATE >= Current selection or my variable )
