topic Subtracting from a variable (not in a set analysis) in QlikView

Subtracting from a variable (not in a set analysis)

sibrulotte — Wed, 06 Nov 2013 16:19:02 GMT

Hi,

I have a rather simple expression:

sum(if([Année financière]= Annee_financiere

AND

[%CLE_Type_Transaction_ID] <>'EB'

AND

[%CLE_Type_Transaction_ID]<>'EA'

AND

[Période financière]<= 12 ,

Montant))

WORKS GREAT !

I'd like another expression to be Annee_financiere -1

So I tried:

sum(if([Année financière]= $(=Annee_financiere -1)

AND

[%CLE_Type_Transaction_ID] <>'EB'

AND

[%CLE_Type_Transaction_ID]<>'EA'

AND

[Période financière]<= 12 ,

Montant))

Returns zeros.

What am I missing. Do I really have to start aiming for a set analysis? If so what would it look like.

Gysbert_Wassenaar — Wed, 06 Nov 2013 17:17:59 GMT

Can you post an example document that explains your problem?

qliksus — Wed, 06 Nov 2013 21:56:08 GMT

Hi,

If Annee_financiere is a variable stores number then use only Annee_financiere-1 instead of $(=Annee_financiere-1).

If it contains some calculation then try any of one from ( $(Annee_financiere)-1) / $(=Annee_financiere)-1

sibrulotte — Thu, 07 Nov 2013 21:40:43 GMT

$(=Anne_financiere)-1

That worked.