Qlikview

[Sonalbjr]

I am trying to use If and sum function while uploading data in qlikview .

The expression that I am using is 

If([xyz]= 'abc', sum([pqr]), 'NA')

But its showing an error. How to use summation inside if statement in qlikview script?

[JuanGerardo]

Probably you want:

Sum(If([xyz]= 'abc', [pqr]))

JG

[duchezbr]

Because sum is an aggregation function, you may need to use Group By [xyz] in your load script. 

Test:

Load

  [xyz]

  If([xyz]='abc', sum([pqr]))

Resident OriginalTable

Group By [xyz];