Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER 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
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