Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count fied from excel

Hi,

I have some data in the excel file where I need to count records who respect determinate condition.

To do so, I have created the following formule:

=count( {<Field1={3405}>} Field1) --> this formula it's OK!

=count( {<Field1<>{3433}>} Field1)  --> This formula it's KO, why?

I want to count all records within the field1 which is different from 3433.

Can you please help me?

Regards

PP

1 Solution

Accepted Solutions
Not applicable
Author

use this:

count( {<Field1 -={3433}>} Field1)

Regards

View solution in original post

2 Replies
Not applicable
Author

use this:

count( {<Field1 -={3433}>} Field1)

Regards

Not applicable
Author

Perfect!

Thank you

PP