# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
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
Valued Contributor

## Re: Formula if sum with 2 field conditions

Try this and let me know

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

3 Replies
Valued Contributor

## Re: Formula if sum with 2 field conditions

Try this and let me know

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

MVP

## Re: Formula if sum with 2 field conditions

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

## Re: Formula if sum with 2 field conditions

Great,

Many thanks Mr. Jebamalai Dass