Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
Try this
= '(' & Concat({< DocumentNumber -= {'5*'} >}DocumentNumber, '|') & ')'
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
Thank you Tresesco
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.