topic Re: Button Help in QlikView

Button Help

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Button Help

tresB — Mon, 09 Oct 2017 10:38:41 GMT

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.

Re: Button Help

techvarun — Mon, 09 Oct 2017 10:41:14 GMT

Try this

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

Re: Button Help

tresB — Mon, 09 Oct 2017 10:52:35 GMT

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

Re: Button Help

techvarun — Mon, 09 Oct 2017 10:55:57 GMT

Thank you Tresesco

Re: Button Help

Anonymous — Mon, 09 Oct 2017 13:25:36 GMT

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.