Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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
Highlighted
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'

Highlighted
Contributor III
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

Highlighted
Partner
Partner

Re: Set analysis

So what is wrong when you use

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

Highlighted
Contributor III
Contributor III

Re: Set analysis

Hi,

try your expression replacing the identiffyer 1 with $:

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

Highlighted
Contributor III
Contributor III

Re: Set analysis

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

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