Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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')