topic Re: Set analysis in QlikView

Set analysis

tim_leijen — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Set analysis

stigchel — Thu, 20 Sep 2018 09:13:25 GMT

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'

Re: Set analysis

tim_leijen — Thu, 20 Sep 2018 09:18:43 GMT

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

Re: Set analysis

stigchel — Thu, 20 Sep 2018 09:26:22 GMT

So what is wrong when you use

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

Re: Set analysis

haupenthals — Thu, 20 Sep 2018 09:27:17 GMT

Hi,

try your expression replacing the identiffyer 1 with $:

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

Re: Set analysis

tim_leijen — Thu, 20 Sep 2018 09:29:14 GMT

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

Re: Set analysis

stigchel — Thu, 20 Sep 2018 09:35:01 GMT

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?