I want to start something different, something I don't think has been done on this forum before, but believe will add a lot of value. A little about my background, I work as a Commercial analyst and have little or no programming experience. I have spent an abundant amount of time on excel (like most) but a part from that, am still very new to the world of relationship databases and QV.
Someone once told me that the best way to learn is through trying to solve problems, and through the journey of completion, you learn about scripting, rules et cetera. This has helped so far, but for someone like me, I often doubt if I am doing things the right way and wondering whether I am learning anything new.
I find that once I get comfortable doing stuff a certain way, that it is hard to try new peices of code or build the report in a completely new way. I believe this to be true for a lot of people.
So enough waffling from me..............for now.... and to the point. This is an open discussion and every week I will uploading a new QV document (available from the downloads page) for us to discuss. Often there is code and ways of doing things that are new and unfamilar for me and a lot of people on this forum.
Through asking questions specific to a QV document and getting the knowledgeable community together, we get a holistic view on how this report was put together and why. Through this process, we learn and also critic what can be done better and so forth. I really hope you all buy into this, and if you think there is a better way I can go about this... please shout
So to start things off.
In the EDIT SCRIPT on the GSCEs page, there is a lot of commented out stuff which makes it a bit difficult to read, but from what I can see...not understand there is a lot of left joins and where not clauses. Exactly what is the person trying to achieve with what they have written. How can I make it easier for me to interpret and understand what is going on
UK Schools Analysis.qvw 6.5 MB