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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
wiz_nerd
Creator
Creator

Textcount function with respect to field.

I am using textcount function  for example the following table  column. In first case when I need the text count of these values I am using this expression.

TextCount ({<String_Field={'string name 1', 'string name 2' }>}String_Field)

which is working fine. whereas in the second example. I need the rest of the values apart from these ones how can I modify the expression to get the values excluding these two because I don't want to mention all the values like the first expression. is there any way to use except or exclude.

 

String_Field
string name 1
string name 2
String class 1
String class 2
'String' class 3
String class 4
String class 5
String class 6
String class 7
String class 8

 

which is working fine. whereas in the second example. I need the rest of the values apart from these ones how can I modify the expression to get the values excluding these two because I don't want to mention all the values like the first expression. is there any way to use except or exclude.

Also if I use the same expression I have a string that consists 'example' when I am trying to write the same expression I am getting error.

however I need the values except these.  For example I want exclude these two values.

string name 1
string name 2

 

 

 

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

Try this

TextCount ({<String_Field -= {'string name 1', 'string name 2' }>}String_Field)

View solution in original post

1 Reply
sunny_talwar

Try this

TextCount ({<String_Field -= {'string name 1', 'string name 2' }>}String_Field)