topic Countif from different sheets in qlik in App Development

Countif from different sheets in qlik

sasidharnovartis — Sat, 16 Nov 2024 02:24:47 GMT

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

Re: Countif from different sheets in qlik

sasidharnovartis — Mon, 18 May 2020 13:10:42 GMT

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