Qlik is all about the data, get that right and your visualisations will be effortless!
I typically bring all my data together into a Star Schema and I’ve written a number of blog posts that talk about how to do this and what you have to keep in mind:
- The Optimal QlikView Data Structure
- A Common QlikView Data Structure Mistake
- Joins, Concatenation and the Applymap function
- Should I link or Concatenate
If you haven't already please take the time to read through these posts!
Joining data, without first knowing your data, can produce unexpected results and will effect your figures. This video talks in detail about how and why that happens.
Note: I’ve recorded the videos in highest resolution possible. So please view them in 1080 or 720P (HD) for best quality. Cheers!