topic replacing formula by variable does not work in QlikView

replacing formula by variable does not work

qlikhans — Thu, 25 Aug 2011 15:33:45 GMT

When I use this formula in a pivot table it just works fine. For each month I get the correct number.

=SUM({$<cat2 = {"V01"}>}Debet)-SUM({$<cat2 = {"V01"}>}Credit)

I want to limit typing, so I defined a variable (ctrl+alt+v) copy/pasting the formule and named the variable "vCalculation" . When using this variable in a pivot table ='$(vCalculation1)', each and every month generates the annual total, the subtotal generated by the pivottable also returns that same annual total. Who can help me?

replacing formula by variable does not work

Thu, 25 Aug 2011 18:19:08 GMT

Hi,

When you define your variable don't put the '=' symbol, so the expression in your varible should be: SUM({$<cat2 = {"V01"}>}Debet)-SUM({$<cat2 = {"V01"}>}Credit) without the '=' and in your object put $(vCalculation) inside the expression

Hope this helps

Regards!

replacing formula by variable does not work

qlikhans — Thu, 25 Aug 2011 20:43:21 GMT

YES!!

Thank you Gabriela, that did the trick.

bst rgrds

Hans