Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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?

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