Count function

[marcel-kro]

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

[igoralcantara · Accepted solution]

Hello and welcome to the Green side of the Force.

Please, try this:

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

[Vaibhav_Pathak]

Hello Marcel,

Try like this -

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

Thanks.

[igoralcantara]

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

[Vaibhav_Pathak]

Okay. Thanks for the information.

[marcel-kro]

It works perfect. Thank a lot for helping.