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

Button to search and exclude 1 value

I have a button set up that currently does this...

 

(5*|6*|2*|*118429308*)

It takes all data in my field that starts with 5, 6, 2, and is 118429308.

I have another button that does this...

 

(1*|0*|8*|7*)

It takes all data in my field that starts with 1, 0, 8, and 7. However, I want it to exclude the number 118429308 even though it starts with a 1.

1 Solution

Accepted Solutions
giakoum
Partner - Master II
Partner - Master II

2 Replies
Siva_Sankar
Master II
Master II

in search use this exp  =sum({} 1)

giakoum
Partner - Master II
Partner - Master II

see an extraordinary solution here :

http://community.qlik.com/message/229000#229000