Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sasidharnovartis
Contributor
Contributor

Countif from different sheets in qlik

Hello 

I have two different tables in my app and created two keys based on fields available in the table

Calls:

A&B&C&D as Calls

Target list:

A&B&C&D as TGTs

 

I want to calculate the number of calls based on the targets (keys) in target list sheet from calls sheet 

Please can anyone help me

Labels (1)
1 Reply
sasidharnovartis
Contributor
Contributor
Author

Hello 

I have two different tables in my app and created two keys based on fields available in the table

Calls:

A&B&C&D as Calls

Target list:

A&B&C&D as TGTs

In excel what i am doing countif(calls a:a,Targetlist a)

I want to calculate the number of calls based on the targets (keys) in target list sheet from calls sheet 

Please can anyone help me