Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
RobMazaheri
Contributor III
Contributor III

Button Navigation

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 

Labels (1)
4 Replies
chriscammers
Partner Ambassador
Partner Ambassador

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.

Screenshot 2024-12-13 141701.jpg

 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.

anat
Master
Master

can you try like below

(if(WildMatch([OWNING_PATCH],'*NORTH*'),0)) 

 

or 

(if(Match([OWNING_PATCH],'NORTH'),0)) 

RobMazaheri
Contributor III
Contributor III
Author

Thanks But this does not work 😞 

nhenckel
Luminary
Luminary

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.

  • Set the field to: PatchGroup
  • Set the value to: 'NORTH' (make sure to include single quotes).