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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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