Now that you've seen how to connect to a data source and load fields from database tables, you may be wondering about how to organize the tabs in the QlikView Script Editor window. It will help to put some thought into the script architecture up front: how will the tabs be organized—by function or by the application tab? How about by data source? How will you handle variables? mapping tables?
It's up to you, and it will probably be a hybrid approach. There are two main schools of thought in the QlikView community about tab organization: some say organize them by data source and some say organize them by QlikView application's (QVW) user interface sheet tabs (for instance, each sheet tab will have a corresponding script tab).
The best way to organize and add tabs is likely the division along data source lines, with no consideration of the final user interface, QVW. Remember that tab order is important and connections and selections must flow in a logical order (promote...