topic Re: Sum () based on type=Active in QlikView https://community.qlik.com/t5/QlikView/Sum-based-on-type-Active/m-p/517877#M193353 <HTML><HEAD></HEAD><BODY><P>Thanks Sokk, it worked perfectly.</P></BODY></HTML> Fri, 13 Sep 2013 07:52:02 GMT 2013-09-13T07:52:02Z Sum () based on type=Active https://community.qlik.com/t5/QlikView/Sum-based-on-type-Active/m-p/517875#M193351 <HTML><HEAD></HEAD><BODY><P>Hi, I want to create a metric based on the type=Active like Sum(Revenue) based on Type=Active How I can implement in Qlikview Chart?? Thanks,</P></BODY></HTML> Fri, 13 Sep 2013 07:40:03 GMT https://community.qlik.com/t5/QlikView/Sum-based-on-type-Active/m-p/517875#M193351 2013-09-13T07:40:03Z Re: Sum () based on type=Active https://community.qlik.com/t5/QlikView/Sum-based-on-type-Active/m-p/517876#M193352 <HTML><HEAD></HEAD><BODY><P>Hi Madu,</P><P></P><P>Your expression should be like this</P><P>Sum({$&lt;[Type]={'Active'}&gt;} Revenue)</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Fri, 13 Sep 2013 07:44:01 GMT https://community.qlik.com/t5/QlikView/Sum-based-on-type-Active/m-p/517876#M193352 Sokkorn 2013-09-13T07:44:01Z Re: Sum () based on type=Active https://community.qlik.com/t5/QlikView/Sum-based-on-type-Active/m-p/517877#M193353 <HTML><HEAD></HEAD><BODY><P>Thanks Sokk, it worked perfectly.</P></BODY></HTML> Fri, 13 Sep 2013 07:52:02 GMT https://community.qlik.com/t5/QlikView/Sum-based-on-type-Active/m-p/517877#M193353 2013-09-13T07:52:02Z