topic Re: Count function in Integration, Extension & APIs

Count function

marcel-kro — Fri, 10 May 2024 11:53:38 GMT

Hello,

I am quite new to Qlik and have no real knowledge yet. So I apologize for what is probably a very simple question for you.

I would like to make an evaluation where I would like to count the number of our invoices using the count function.

The problem is that the same field which is called "Document No." also contains delivery note numbers.

I only want to count the invoices that start with AR....

Which settings should I make?

I hope you can help me

Re: Count function

igoralcantara — Fri, 10 May 2024 12:37:32 GMT

Hello and welcome to the Green side of the Force.

Please, try this:

Count({$<[Document No]={"AR*"}>} Distinct [Document No])

Re: Count function

Vaibhav_Pathak — Fri, 10 May 2024 13:34:33 GMT

Hello Marcel,

Try like this -

COUNT(IF(Document No. LIKE 'AR*' , Document No.))

Thanks.

Re: Count function

igoralcantara — Fri, 10 May 2024 14:16:32 GMT

If statements are usually not recommended in expressions, since it provides a worse performance than Set Analysis, which is what I am proposing above.

Re: Count function

Vaibhav_Pathak — Sat, 11 May 2024 12:00:44 GMT

Okay. Thanks for the information.

Re: Count function

marcel-kro — Mon, 13 May 2024 06:14:40 GMT

It works perfect. Thank a lot for helping.