How would you describe a: a) Dashboard b) MI solution
Basic BI / MI knowledge
What is it that drew you to working with QlikView
Response around solutions that can be delivered / end user satisfaction - rather than a feature list
Describe some of the solutions you have built in QlikView
Applicacations around finance / insurance
What parts of QlikView project life cycles have you been involved in
Comfortable in dealing with people as well as software
What feature of QlikView would you like best, and why
This one is subjective - but may draw an interesting response
What would you say the limitations / flaws with QlikView are
Again very subjective
What presentation object would best suit......
Holds an opinion on basic data presentataion
What is a QVD file and why might you use one
It's a data repository file, can aid a robust / quick reload strategy, essential for incremental loads of data
What is the difference between optimized and non optimized QVD load
When retreiving from QVD optimized mode is up to 100x quicker - only works if you follow a set of rules
Describe the use of the ApplyMap statement
Used for mapping data from one source onto another at load time, very flexible in how it does this
How might you seek to decrease memory usage by a document
Drop redundant items, remove granularity (eg. drop time from datetime fields), split fields (eg. post codes)
What kind of optimisations can be done to data models
Merge tables to reduce joins at run time - create a flatter structure at load time
Describe the crosstab directive; how and why would you use it
Transforms columns into rows by dimensions (eg. in Excel where have cols for description then one col per month)
What is a calculation condition and why would you use one
Stops a potentially costly calculation / display taking place by checking a more efficient expression first
What is a show condition and how does it differ from calculation condition
Similar to calculation condition but the object is removed from the screen rather than displaying a message
What are the advantages of using a theme
Contains all UI attributes in a single file, when new objects are created they can pick up from the theme
Why might you make use of variables
Can keep re-useable code snippets, calculate values for global use, maintaining state of objects
Also additional attached.
Of course the subject matter could be very wide and depends on whether your role is more toward dashboard development / scripting, small scale or large scale etc etc.
