Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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
Partner

=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
Partner

=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

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