topic Domanda in QlikView https://community.qlik.com/t5/QlikView/Domanda/m-p/695740#M676902 <HTML><HEAD></HEAD><BODY><P>How can i replicate the excel condition count if? And also, how is it possible to choose to different type of cells in a column: can we use a filter or there's a special formula to do this?</P></BODY></HTML> Tue, 17 Jun 2014 16:31:08 GMT 2014-06-17T16:31:08Z Domanda https://community.qlik.com/t5/QlikView/Domanda/m-p/695740#M676902 <HTML><HEAD></HEAD><BODY><P>How can i replicate the excel condition count if? And also, how is it possible to choose to different type of cells in a column: can we use a filter or there's a special formula to do this?</P></BODY></HTML> Tue, 17 Jun 2014 16:31:08 GMT https://community.qlik.com/t5/QlikView/Domanda/m-p/695740#M676902 2014-06-17T16:31:08Z Re: Domanda https://community.qlik.com/t5/QlikView/Domanda/m-p/695741#M676903 <HTML><HEAD></HEAD><BODY><P>You can use count with if in qlikview </P><P></P><P>Count(If(Type='Domestic', [Policy No] ) )</P><P></P><P>What do you mean by type of cell if it is particular location then you can use</P><P></P><P>Peek('AMOUNT' ,5,'Tab1');</P><P></P><P>Or</P><P></P><P><SPAN class="Bold">Lookup(</SPAN><SPAN class="Italic">fieldname, matchfieldname, matchfieldvalue [, tablename]</SPAN><SPAN class="Bold">);</SPAN></P><P><SPAN class="Bold"><BR /></SPAN></P><P><SPAN class="Bold">Eg:-&nbsp; </SPAN>Lookup('Price', 'ProductID', InvoicedProd, 'pricelist')</P></BODY></HTML> Tue, 17 Jun 2014 17:29:59 GMT https://community.qlik.com/t5/QlikView/Domanda/m-p/695741#M676903 its_anandrjs 2014-06-17T17:29:59Z