A few do's and don'ts
There are some things you should always do, and some you just shouldn't! You will find many little things in QlikView that you need to lock away in your memory, and they'll all add to your overall skill level.
Background
Some do's and don'ts may be thought of as best practice or useful site standards, but here are a few that work better on a personal level.
How to do it
Do:
- Use F1: QlikView's syntax is different from other languages. Use the F1 key to bring up context-sensitive help, showing you the full syntax and parameter list. This helps you learn the syntax and helps ensure that you get the correct results from the start.
- Drop Table: Drop Table in the script is a good way of making things more efficient. Remember, though, that dropping one table with identical fields to another will drop both!
- Drop Fields: If you drop fields, use a list rather than individual statements; it is much more efficient.
- Use the fora: Sometimes, QlikView throws...
