Textcount function with respect to field.

wiz_nerd — Sat, 16 Nov 2024 21:32:08 GMT

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

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

Re: Textcount function with respect to field.

sunny_talwar — Fri, 25 Jan 2019 14:58:47 GMT

Try this

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

topic Textcount function with respect to field. in QlikView

Textcount function with respect to field.

Re: Textcount function with respect to field.