Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: Domanda

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

Community Browser