Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Data selection

Hello

A column, there are three types of data.

What is the formula sui allows me to get:

the number of data 1

Thank you for your help

4 Replies
MK_QSL
MVP
MVP

What is the question?

Anonymous
Not applicable
Author

what formula can I count the number of data of type 1 in the data set

Anonymous
Not applicable
Author

Qlik only has two datatypes, Num and Text.

You can count in the field using IsText for text;

=count(if(IsText(YourField),YourField))

and IsNum for Numbers;

=count(if(IsNum(YourField),YourField))

Anonymous
Not applicable
Author

Sorry

it doesn't work