Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

karllyon
New Contributor III

Set analysis problem in straight table

Hi,

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').

Cheers

Karl

2 Replies
jason_michaelid
Honored Contributor II

Re: Set analysis problem in straight table

What is the set analysis expression you are using? I suspect it is cancelling the Year selection.

MVP
MVP

Re: Set analysis problem in straight table

Hi,

Check attached file, hope it helps you.

Regards,

Jagan.

Community Browser