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: 
khag_hs
Contributor II
Contributor II

set analysis with data containing operators as text

I have some
data with the character “*” and “/”. These characters are mean as characters, not as operators.

If I use the set analysis function

=count({$<Field={“*”}>Field)

the count is done over all data.

What can I do to count only the fields containing the character “*”?

1 Solution

Accepted Solutions
sunny_talwar

What if you try this:

=Count({$<Field={" =Field = '*' "}>Field)

View solution in original post

2 Replies
sunny_talwar

What if you try this:

=Count({$<Field={" =Field = '*' "}>Field)

khag_hs
Contributor II
Contributor II
Author

thank you, it works