Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
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
jebamalai
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
jebamalai
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)

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

Community Browser