topic Re: SUMIF function in excel Equivalent in function Qlikview in QlikView https://community.qlik.com/t5/QlikView/SUMIF-function-in-excel-Equivalent-in-function-Qlikview/m-p/1329068#M410803 <HTML><HEAD></HEAD><BODY><P>Looks like you need ApplyMap() to map the mapping table.</P></BODY></HTML> Wed, 02 Aug 2017 12:04:10 GMT Anil_Babu_Samineni 2017-08-02T12:04:10Z SUMIF function in excel Equivalent in function Qlikview https://community.qlik.com/t5/QlikView/SUMIF-function-in-excel-Equivalent-in-function-Qlikview/m-p/1329065#M410800 <HTML><HEAD></HEAD><BODY><P>Hi..</P><P></P><P>Can anyone help me how can i write the below expression in Qlikview </P><P></P><P>=SUMIF('Jun17'!$AG:$AG, 'FF-JUN'!$E3&amp;"YES", 'Jun17'!$AB:$AB)</P><P></P><P><SPAN style="font-size: 13.3333px;">Jun17'!$AG:$AG = IF($P2 &lt;&gt; "Sample" , IF ( U2 &gt; 0, H2 ,0 ) , 0)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">P2 = IteamCategory</SPAN></P><P><SPAN style="font-size: 13.3333px;">U2 = Qtyvalidated</SPAN></P><P><SPAN style="font-size: 13.3333px;">H2 = Name</SPAN></P><P></P><P><SPAN style="font-size: 13.3333px;">Jun17'!$AB:$AB = Received data </SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">I tired few values are matching but few are not...<BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Regards</SPAN></P><P><SPAN style="font-size: 13.3333px;">hemanth<BR /></SPAN></P></BODY></HTML> Tue, 01 Aug 2017 11:42:14 GMT https://community.qlik.com/t5/QlikView/SUMIF-function-in-excel-Equivalent-in-function-Qlikview/m-p/1329065#M410800 hemanthaanichet 2017-08-01T11:42:14Z Re: SUMIF function in excel Equivalent in function Qlikview https://community.qlik.com/t5/QlikView/SUMIF-function-in-excel-Equivalent-in-function-Qlikview/m-p/1329066#M410801 <HTML><HEAD></HEAD><BODY><P>Would you be able to share your Excel?</P></BODY></HTML> Tue, 01 Aug 2017 11:45:32 GMT https://community.qlik.com/t5/QlikView/SUMIF-function-in-excel-Equivalent-in-function-Qlikview/m-p/1329066#M410801 sunny_talwar 2017-08-01T11:45:32Z Re: SUMIF function in excel Equivalent in function Qlikview https://community.qlik.com/t5/QlikView/SUMIF-function-in-excel-Equivalent-in-function-Qlikview/m-p/1329067#M410802 <HTML><HEAD></HEAD><BODY><P>Brother any idea u have for this.... pls let me know....</P></BODY></HTML> Wed, 02 Aug 2017 11:54:54 GMT https://community.qlik.com/t5/QlikView/SUMIF-function-in-excel-Equivalent-in-function-Qlikview/m-p/1329067#M410802 hemanthaanichet 2017-08-02T11:54:54Z Re: SUMIF function in excel Equivalent in function Qlikview https://community.qlik.com/t5/QlikView/SUMIF-function-in-excel-Equivalent-in-function-Qlikview/m-p/1329068#M410803 <HTML><HEAD></HEAD><BODY><P>Looks like you need ApplyMap() to map the mapping table.</P></BODY></HTML> Wed, 02 Aug 2017 12:04:10 GMT https://community.qlik.com/t5/QlikView/SUMIF-function-in-excel-Equivalent-in-function-Qlikview/m-p/1329068#M410803 Anil_Babu_Samineni 2017-08-02T12:04:10Z Re: SUMIF function in excel Equivalent in function Qlikview https://community.qlik.com/t5/QlikView/SUMIF-function-in-excel-Equivalent-in-function-Qlikview/m-p/1329069#M410804 <HTML><HEAD></HEAD><BODY><P>Anil Applymap is not possible i think because the raw data is a single file</P></BODY></HTML> Wed, 02 Aug 2017 12:17:00 GMT https://community.qlik.com/t5/QlikView/SUMIF-function-in-excel-Equivalent-in-function-Qlikview/m-p/1329069#M410804 hemanthaanichet 2017-08-02T12:17:00Z