Button Help

[Anonymous]

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

[tresesco]

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]

Try this

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

[tresesco · Accepted solution]

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]

Thank you Tresesco

[Anonymous]

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.