Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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