topic using variable in formula in QlikView

using variable in formula

qlikhans — Wed, 31 Aug 2011 18:43:25 GMT

Hi,

I have defined a variable vGL_mutatie as sum({$}Debet)-sum({$}Credit). In a pivot table =$(vGL_mutatie) works. Now I want to apply this variable to the formula sum(if (InYear (Boekdatum, Today(), -1), Debet))-sum(if (InYear (Boekdatum, Today(), -1), Credit)).

I tried several varaties, such as :

if (InYear (Boekdatum, Today(), -1, $(vGL_mutatie)))

sum(if (InYear (Boekdatum, Today(), -1, vGL_mutatie)))

who helps me out?

kind regards

Hans

using variable in formula

Wed, 31 Aug 2011 18:54:33 GMT

Hi Hans ,

can you try this

if (InYear (Boekdatum, Today(), -1, $(=(vGL_mutatie))))

hope may be it fixs your issue

thanks

Meher

using variable in formula

qlikhans — Wed, 31 Aug 2011 19:05:16 GMT

Hi Meher,

Sorry, does not fix it. It returns only '-'.

knd rgrds

Hans

using variable in formula

Wed, 31 Aug 2011 20:10:08 GMT

Hans ,

Can you try to save the value of vGL_mutatie into another variable and use that variable in the InYear function ,because while using $(vGL_mutatie) refers to the setanalysis and tries to pull the value from set but where it seems like we can't use setanalysis in a InYear function .

I'm not sure it will work but try to take a chance

thanks

Meher

using variable in formula

qlikhans — Thu, 01 Sep 2011 17:05:11 GMT

Hi Meher,

too complicated for a novice like me.

Do you think there would be an easy method to add up Debit and Credit while loading the script?

kind regards

Hans