SUMIF function in excel Equivalent in function Qlikview

[hemanthaanichet]

Hi..

Can anyone help me how can i write the below expression in Qlikview

=SUMIF('Jun17'!$AG:$AG, 'FF-JUN'!$E3&"YES", 'Jun17'!$AB:$AB)

Jun17'!$AG:$AG = IF($P2 <> "Sample" , IF ( U2 > 0, H2 ,0 ) , 0)

P2 = IteamCategory

U2 = Qtyvalidated

H2 = Name

Jun17'!$AB:$AB = Received data

I tired few values are matching but few are not...

Regards

hemanth

[sunny_talwar]

Would you be able to share your Excel?

[hemanthaanichet]

Brother any idea u have for this.... pls let me know....

[Anil_Babu_Samineni]

Looks like you need ApplyMap() to map the mapping table.

[hemanthaanichet]

Anil Applymap is not possible i think because the raw data is a single file