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

    Domanda

      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');

           

          Or

           

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


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