Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to use buttons to navigate to a field but its not working , I dont want to use a filter pane I want separate buttons
ive tried using =(if(WildMatch([OWNING_PATCH],'NORTH'),0)) but it wont work
can anyone help please
I think there is an option here using the relatively new cyclic group available in sense.
While the button approach seems a little clunky to me I'll play along.
I added a table to list the fields I would like to offer in the list. the fields are a label and the actual name of the field you would like to show.
List:
load * inline [
FLabel,FNAme
Item,@Content
Year,DatePublished Year
];
Then in the case of Dimensions I add the following expression in the dimension definition
=$(=SubField(Concat('[' & FNAme & ']','||'),'||',1))
And then this expression for the label
=SubField(Concat(FLabel,'||'),'||',1)
As you can see the list box will control what field is displayed in the right hand field but you can use the expressions in any dimension field definition.
Then you can use your button to set the label selection how ever you want I recommend you clear the selection and then set it to the new value.
can you try like below
(if(WildMatch([OWNING_PATCH],'*NORTH*'),0))
or
(if(Match([OWNING_PATCH],'NORTH'),0))
Thanks But this does not work 😞
It sounds like you want buttons to navigate or filter values in a field without using a filter pane. The cleanest approach here is to create an additional field in the data load script that simplifies the filtering process. For example:
LOAD *,
if(WildMatch([OWNING_PATCH], 'NORTH'), 'NORTH', 'OTHER') as PatchGroup;
This creates a new field PatchGroup
with simplified values (NORTH
or OTHER
) based on the condition.
For the button, use the "Select values in a field" action, and target the new field PatchGroup
.
PatchGroup
'NORTH'
(make sure to include single quotes).