Thank you so much for your reply, i am hoping to restrict records by the user entering parameters on the front to be used on the sql back end
similar to sql/crystal reporting parameters.
Is this possible
ie select * from tblA where date > '?start_date' and < '?end_date?'
upon opening the qlikview project the user will be prompted to enter a start and end date, which will complete the sql on the backend, thuis generating results
This can be possible, Please find the attached application where i connected to MS Access database and restricted with input parameters through front end and passing those values in back end.
LastName where EmployeeBusinessEntityID >= $(vfrom) and EmployeeBusinessEntityID <= $(vto);
SQL SELECT EmployeeBusinessEntityID,
I am not able to attach the application but this script may help you and create two input boxes and passed the values into where clause.
Let me know if this is not the case.