problem with the loop getting this error can anyone say me why i am getting it
One or more loops have been detected in your database structure. Loops may cause ambiguous results and should therefore be avoided. QlikView will cut the loop(s) by setting one or more tables as loosely coupled. Settings for loosely coupled tables can be modified after script execution in the tables page of the document properties dialog.
Because you have a data model with circular references - which QlikView cannot resolve.
Press <ctrl>-t to see the data model you have loaded. Then ask yourself if you really want all keys/links that you have in your data model. Then change the script by renaming some fields, so that you do not get the same links.