As newbie in Qlikview I am currently trying to found it's possibilities.
I have the following data set:
Measure Year Month Store Value
Sales 2010 Jan 1 100
Profit 2010 Jan 1 10
Sales 2010 Feb 1 200
Profit 2010 Feb 1 25
I want to create pivot table, which next to sales, profit also contains profit % (= profit/sales) for the shown store/month. In other words to do a calculation across the dimension based on the shown selection in other dimensions.
I'm not saying that the set analysis approach will not work but I think you will be making some serious usability compromises in your data model if you don't transform the data. Any user who you share this document with will have to master Set analysis just to produce a simple sales chart. If you separate sales and profit into separate columns then the user only needs to sum the column they want.
Check out the attachment and you can decide what you want to do, each approach will work.
I like Chris's method and his justification is equally matched. Just one question Chris, why exactly do you on the join statement, list all fields again. Could you not just load the Profit part and join.