Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
brunobarbier
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
Not applicable

Re: Data selection

What is the question?

brunobarbier
Not applicable

Re: Data selection

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

gareth_wilson12
Not applicable

Re: Data selection

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))

brunobarbier
Not applicable

Re: Data selection

Sorry

it doesn't work