Domanda

[#1]

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?

[its_anandrjs]

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