Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bansefi01
New Contributor

SUM IF

I have the following table

RECLAMADAIMP_APNTE
#N/A142536
124578963300
#N/A5000
35489785235152456
54879542335630065

I need to add ONLY those values with RECLAMADA field different than #N/A

I'm trying with this formula but the outcome is ZERO.. any ideas ?

If(RECLAMADA = '#N/A', 1, Sum(IMP_APNTE))

thanks

Tags (2)
4 Replies
luismadriz
Valued Contributor

Re: SUM IF

Hi,


please try this one as the measure

Sum({<RECLAMADA -= {"#N/A"}>} IMP_APNTE)


And only leave RECLAMADA as the dimension,


I hope this helps


Saludos


Luis

bansefi01
New Contributor

Re: SUM IF

Thanks, I´ll try it, Is for a KPI

devarasu07
Honored Contributor II

Re: SUM IF

Hi,

yes u can apply this set expression in both object (kpi , stright table etc). refer to the sample attached

Capture.JPG

Capture.JPG

luismadriz
Valued Contributor

Re: SUM IF

Hi Fernando,

When applicable please mark the appropriate replies as Correct. This will help community members know which discussions have already been addressed and have a possible known solution. Please mark replies as Helpful if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as Helpful if you feel additional info is useful to others


Cheers,


Luis