Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! 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