Discussion board where members can get started with QlikView.
I have created a straight table to display a data set by year. The table uses set analysis to compare with last year.
However, the set analysis creates a new row (previous year) in the table (see attached).
In the attached '2012' is a selected value. You will note that the row '2011' has been created and the set analysis for previous year (Prev Yr) is inserted on this row.
How can I remove to automatic creation of the previous year's row (2011) and move the 'Prev Yr' set analysis calculation (value showing 94) to the row above it ('2012').
What is the set analysis expression you are using? I suspect it is cancelling the Year selection.
Check attached file, hope it helps you.