topic Set analysis problem in straight table in QlikView

Set analysis problem in straight table

Anonymous — Fri, 31 Aug 2012 02:46:30 GMT

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

Re: Set analysis problem in straight table

Jason_Michaelides — Fri, 31 Aug 2012 05:36:29 GMT

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

Re: Set analysis problem in straight table

jagan — Fri, 31 Aug 2012 07:17:56 GMT

Hi,

Check attached file, hope it helps you.

Regards,

Jagan.