Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Button Help

Hi guys

If I were to create a button in Qlikview, Is there any way I could set it to exclude all records in my "Document Number" field that begin with a "5"?

Many thanks,

Gareth

1 Solution

Accepted Solutions
tresesco
MVP
MVP

If it's about making selection using trigger, using DISTINCT and using double quotes for search instead of single quotes would be recommended, like:

= '(' & Concat(Distinct {< DocumentNumber -= {"5*"} >}DocumentNumber, '|') & ')'


Note: Single quotes work, still to make it future-proof it's better to use the right one, i.e. - double quotes. Please refer: Quotes in Set Analysis

View solution in original post

5 Replies
tresesco
MVP
MVP

Exclude from ? a chart? If so, what is the dimension/expression you are using? You might have to provide a bit more info, a better option is to create/share a sample app where we can work unpon.

techvarun
Specialist II
Specialist II

Try this

= '(' & Concat({< DocumentNumber -= {'5*'} >}DocumentNumber, '|') & ')'

sample.PNG

tresesco
MVP
MVP

If it's about making selection using trigger, using DISTINCT and using double quotes for search instead of single quotes would be recommended, like:

= '(' & Concat(Distinct {< DocumentNumber -= {"5*"} >}DocumentNumber, '|') & ')'


Note: Single quotes work, still to make it future-proof it's better to use the right one, i.e. - double quotes. Please refer: Quotes in Set Analysis

techvarun
Specialist II
Specialist II

Thank you Tresesco

Anonymous
Not applicable
Author

There are several options to do this.

A way I like is to create a selectionfield in your script (it is not needed but it makes it a bit easier).

Somthing like:

Table:

Load

          Document,

          IF(Left(Document,1) =5 , 'yes', 'no' ) as Selctionfield

Resident YourDataSource;

You kan use this Selectfield in you Qlikview document or create a button with a selection action in it.