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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
marikabi
Creator
Creator

BUTTON - SELECT IN THE FIELD

Hello guys,

I am trying to use a button that select in the field "Sales" all the values that are greater than 7.000, excluding the values 10.000 and 20.000.

How should I write the search string?

Many thanks in advance,

Regards,

Marika

Labels (1)
1 Solution

Accepted Solutions
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Use the Triggers.

Screenshot_1.jpg

See the attachment and you easily catch an idea.

View solution in original post

4 Replies
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Use the Triggers.

Screenshot_1.jpg

See the attachment and you easily catch an idea.

marikabi
Creator
Creator
Author

not really helpful to be honest

Anonymous
Not applicable

Hi,

You could have two expressions that has conditional show and hide based on a variable value.

The button could toggle the variable value and show the filtered values expression or all values expression.

Sample attached.

Hope this helps!

marikabi
Creator
Creator
Author

Sorry, I couldn't open the attachment.

It does work!

Thank you