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: 
Not applicable

Formula if sum with 2 field conditions

Hi guys,

Somebody help me,

How to write the formula if I want to create :

field 'a',  sum({<Year={Max(Year))}, Field_B={'Handphone'}, Field_C={'Komputer'}>} Amount),

how to write with correct formula?

Thanks before

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Try this and let me know

sum({$<Year=Max(Year), Field_B={'Handphone'}, Field_C={'Komputer'}>} Amount)

View solution in original post

3 Replies
Anonymous
Not applicable
Author

Try this and let me know

sum({$<Year=Max(Year), Field_B={'Handphone'}, Field_C={'Komputer'}>} Amount)

its_anandrjs

Try to write like

=Sum( {< Year = {'$(=Max(Year) )' }, Field_B = {'Handphone'}, Field_C = {'Komputer'}>} Amount)


Or


=Sum( {< Year = {"$(=Max(Year) )" }, Field_B = {Handphone}, Field_C = {'Komputer}>} Amount)

Not applicable
Author

Great,

Many thanks Mr. Jebamalai Dass