I am trying to build a qlikview report where there is a possibility to compare sales for periods that are defined by custom dates. For example, a user chooses a year of 2005 and monthes of May, April, March, then, he wants to copare them with the following data, a year of 2008 and monthes of December, January, February. To solve it, i use Pivot table to show my data and two ListBoxes for yeach period to choose dates(the first year and the first mothes are in the alternate state "time1", the second year and monthes are a state "time2"). In addition, as i don't have Dimension, i use Synthetic Dim. as ValueLoop().
QlikView does not correct recognise the year the sales are calculated(the calculations are correct!), it only shows the value from valueloop, that goes next after selected period 1(if i choose the year of 2005, QV shows 2006).
[Using different combinations of code], If a user chooses a year of 2005 from ListBox(state "time1") and monthes of May, April, March(another ListBox with state "time1"), then, he chooses from another ListBoxes(with the state "time2") a year of 2005 and monthes of December, January, February, QlikView shows only the year of 2005 as a single row(I want him to show two rows with 2005 years, but for different mothes).
Your pick-match combination will always pick the same expression for 2006, i.e. the one that uses alternate state time2. So whatever year you select in time2 is used for the row of 2006. You probably want to use something with no dimension (or at least without your calculated dimension) and two expressions. See attached qvw.
Edit: I've created a straight table object with no dimensions and two expression:
You could try using text boxes instead. Since the expressions are supposed to return only one number, not a set of rows like your example with the Year dimension, you can use the expressions in text boxes too. Then you can add as many text boxes for labels and expressions as you want and format them so the whole looks pretty. This is more work than using a straight table or pivot table object, but you have a lot more flexibility in layout and formatting.