Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis

EMP_PHONE EMP_TOWN EMP_ID
01628-198371Cookham307
01628-187632Windsor306
01628-782364Cookham305
01628-243535Maidenhead304
01628-567231Maidenhead303
01628-834582Maidenhead302
01628-764234Slough301
12-54-11-10New York209
22-52-22-00New York208
12-85-01-61New York207
12-33-51-29Long Island206
12-56-55-20New York205
14-44-11-66New York204
22-36-25-50New York203
22-54-11-10New York202
12-24-26-44New York201
14-54-11-10Los Angeles111

i loaded this data when i am using the text object to count EMP_ID its is showing actual text in the text box

in text box i use condition count(EMP_ID)

1 Solution

Accepted Solutions
Not applicable
Author

Hi

Did you use;

=count([EMP_ID])

The square brackets are important as well as the equal sign.


Regards


Steve

View solution in original post

3 Replies
Not applicable
Author

Hi

Did you use;

=count([EMP_ID])

The square brackets are important as well as the equal sign.


Regards


Steve

Not applicable
Author

Hi Vinay,

You will have to use '=' sign before count i.e.

=Count(EMP_ID) instead of just count(EMP_ID).

Hope this helps!


Not applicable
Author

Hi Steve,

Square brackets are not required because in your case, you have used _(like EMP_ID)..

So you can put an equal sign to make things work!