1 Reply Latest reply: Jun 17, 2014 1:30 PM by Anand Chouhan RSS


      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?

        • Re: Domanda
          Anand Chouhan

          You can use count with if in qlikview


          Count(If(Type='Domestic', [Policy No] ) )


          What do you mean by type of cell if it is particular location then you can use


          Peek('AMOUNT' ,5,'Tab1');




          Lookup(fieldname, matchfieldname, matchfieldvalue [, tablename]);

          Eg:-  Lookup('Price', 'ProductID', InvoicedProd, 'pricelist')