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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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