topic Re: Problem in calculation condition in Pivot.. in QlikView https://community.qlik.com/t5/QlikView/Problem-in-calculation-condition-in-Pivot/m-p/813827#M1047098 <HTML><HEAD></HEAD><BODY><P>Hi Vijay,</P><P></P><P>&nbsp;&nbsp; If you don't want the value of "a" then you can filter out at WHERE condition it self.</P><P></P><P></P><P>-Jay</P></BODY></HTML> Wed, 12 Nov 2014 11:16:39 GMT Anonymous 2014-11-12T11:16:39Z Problem in calculation condition in Pivot.. https://community.qlik.com/t5/QlikView/Problem-in-calculation-condition-in-Pivot/m-p/813824#M1047095 <HTML><HEAD></HEAD><BODY><P>In Table Structure one column is brand where brand is three type a,b and c .</P><P>when we create pivot table i want to take only two brand data a and b how to achieve it please suggest....</P></BODY></HTML> Wed, 12 Nov 2014 10:24:12 GMT https://community.qlik.com/t5/QlikView/Problem-in-calculation-condition-in-Pivot/m-p/813824#M1047095 vijayit43 2014-11-12T10:24:12Z Re: Problem in calculation condition.. https://community.qlik.com/t5/QlikView/Problem-in-calculation-condition-in-Pivot/m-p/813825#M1047096 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Similar question answered here</P><P><A _jive_internal="true" href="https://community.qlik.com/thread/141776">http://community.qlik.com/thread/141776</A></P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Wed, 12 Nov 2014 10:25:33 GMT https://community.qlik.com/t5/QlikView/Problem-in-calculation-condition-in-Pivot/m-p/813825#M1047096 ashfaq_haseeb 2014-11-12T10:25:33Z Re: Problem in calculation condition.. https://community.qlik.com/t5/QlikView/Problem-in-calculation-condition-in-Pivot/m-p/813826#M1047097 <HTML><HEAD></HEAD><BODY><P>try like this</P><P>sum({&lt;brand={'a','b'}&gt;}sales)</P></BODY></HTML> Wed, 12 Nov 2014 10:26:20 GMT https://community.qlik.com/t5/QlikView/Problem-in-calculation-condition-in-Pivot/m-p/813826#M1047097 2014-11-12T10:26:20Z Re: Problem in calculation condition in Pivot.. https://community.qlik.com/t5/QlikView/Problem-in-calculation-condition-in-Pivot/m-p/813827#M1047098 <HTML><HEAD></HEAD><BODY><P>Hi Vijay,</P><P></P><P>&nbsp;&nbsp; If you don't want the value of "a" then you can filter out at WHERE condition it self.</P><P></P><P></P><P>-Jay</P></BODY></HTML> Wed, 12 Nov 2014 11:16:39 GMT https://community.qlik.com/t5/QlikView/Problem-in-calculation-condition-in-Pivot/m-p/813827#M1047098 Anonymous 2014-11-12T11:16:39Z