Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Charles_FMCC
Contributor II
Contributor II

Variables in Sum formula

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?

1 Solution

Accepted Solutions
eddie_wagt
Partner - Creator III
Partner - Creator III

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

 

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

 

Regards Eddie

View solution in original post

2 Replies
eddie_wagt
Partner - Creator III
Partner - Creator III

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

 

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

 

Regards Eddie

Charles_FMCC
Contributor II
Contributor II
Author

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