# New to QlikView

Discussion board where members can get started with QlikView.

New Contributor III

## Set analysis

Good morning all,

I'm trying to figure out set analysis, and got an issue of which I'm not sure how to solve it.

So what I want to reach, is a column to show the full last year volumes of fiscal year 2018, but it should still adapt when I select a dimension. So for instance if I would select one of our brand partners, it should show the full last year volumes of this brand partner.

The expression I've created is  sum({1<GL_4={VOL}, FiscalYear = {2018} ,Dimension={LY}>} Data)  which does show the full last year data, but doesn't change when I make a selection on one of the dimensions.

6 Replies
Partner

## Re: Set analysis

When you specify Sum({1 .. you disregard any selections, if you want to include other selections then specifiied in your set analysis use Sum({\$... Also how does Dimension={LY} relate to your ' when I make a selection on one of the dimensions'

New Contributor III

## Re: Set analysis

Hi Piet Hein,

So I want Qlikview to amend the data to all dimensions I'm selecting, apart from the two in my expression. So it needs to show full last year data of any dimension I select

Partner

## Re: Set analysis

So what is wrong when you use

sum({\$<GL_4={VOL}, FiscalYear = {2018} ,Dimension={LY}>} Data)

Highlighted
New Contributor III

## Re: Set analysis

Hi,

try your expression replacing the identiffyer 1 with \$:

=sum({\$<GL_4={VOL}, FiscalYear = {2018} ,Dimension={LY}>} Data)

New Contributor III

## Re: Set analysis

I'm not sure, there is no data showing when I replace the 1 with a \$

Partner

## Re: Set analysis

I don't know your data model, dimensions etc. If you don't know, how should I? Can you share your qvw or a sample that demonstrates your problem?