Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

tim_leijen
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
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'

tim_leijen
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
Partner

Re: Set analysis

So what is wrong when you use

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

Highlighted
haupenthals
New Contributor III

Re: Set analysis

Hi,

try your expression replacing the identiffyer 1 with $:

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

tim_leijen
New Contributor III

Re: Set analysis

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

Partner
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?