topic Re: Variables in Sum formula in QlikView

Variables in Sum formula

Charles_FMCC — Thu, 20 May 2021 14:05:38 GMT

I have this formula:

(sum( {$<FieldA = {'1'}>} FieldB))

I would like to replace the {'1'} with a variable but can't seem to get the syntax correct. Can someone help me with this?

Re: Variables in Sum formula

eddie_wagt — Thu, 20 May 2021 14:41:18 GMT

=sum( {$<FieldA = {'$(variable)'}>} FieldB)

This should do. If it is not working, you should analyze how the variable has been declared.

Regards Eddie

Re: Variables in Sum formula

Charles_FMCC — Fri, 21 May 2021 15:46:54 GMT

Thanks Eddie, that worked. I am still trying to learn the exact syntax for some of these equations when and where to use them. Thanks for the quick response.

Charles