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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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