topic Re: set analysis problem in QlikView

set analysis problem

Mon, 26 Jan 2026 18:19:17 GMT

Hi qlikview experts,

I'm using a pivot table with two dimensions custumers and years for statistics as shown in the attached picture ,I got to have the differnce between the year and the previous year in money and quantity , and im using this expression:for diff an-1 ..

(sum({<[Ecriture_Article. Type]={1}>}[Ecriture_Article. Sales Amount (Actual)]+[Ecriture_Article. Sales Amount (Expected)])

-sum({<[Ecriture_Article. Type]={1},[Année]={"$(= &Année) "}-{1}>}[Ecriture_Article. Sales Amount (Actual)]+[Ecriture_Article. Sales Amount (Expected)]))

but it gives me 0 as result

thx in advance.

Re: set analysis problem

jonathandienst — Wed, 26 Mar 2014 08:33:21 GMT

Your second sum statement is unclear:

Is &Année a field name or variable?
What is the purpose of the {< .... {1}>}? I think this is causing QV to ignore the Année field selection, so the two sum statements evaluate to the same value.
Do you mean [Année]={"$(= &Année - 1)"}?

HTH

Jonathan

Re: set analysis problem

Wed, 26 Mar 2014 08:41:41 GMT

Hi jonathan ,

Année is a variable that takes the year of the field date and for the third remark, yes that's what i ment i tried it and it gaved me 0 .

regards.

;

Re: set analysis problem

jonathandienst — Wed, 26 Mar 2014 09:14:52 GMT

Try each Sum() expression on their own. Are they both returning zero, or are they returning the same value?

Re: set analysis problem

jonathandienst — Wed, 26 Mar 2014 09:16:05 GMT

Oh, and that syntax (...-{1}) was incorrect. My suggestion is valid syntax as far as I can see.

Re: set analysis problem

Wed, 26 Mar 2014 09:49:38 GMT

Mr Jonathan,

the first sum is correct but not the second

regards

Re: set analysis problem

jonathandienst — Wed, 26 Mar 2014 14:46:54 GMT

You can explore the effect of the second expression by seeing how the first expression.reacts when you make selections in Année (or other fields).

A set expression is basically a selection that takes place inside an expression, so you can see the effect of various selections and what you need to do to get the correct selections. Then you can write the set expression to mimic the manual selections.

If you need more help, I suggest that you upload a sample qvw file that illustrates the problem.