Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Button Toggel Selections

Guys,

I am trying to use a button to toggle between a selection of [IM Submitter RA] = 'GSK-SERVICEDESK-APAC' and 'GSK-SERVICEDESK'

I can us the code below with one value at a time, can work out how to toggle between both values and no values. 

I've tried something like this, but obviously, that doesn't work.

=If(GetFieldSelections([IM Submitter RA])='GSK-SERVICEDESK-APAC', '<> GSK-SERVICEDESK-APAC', 'GSK-SERVICEDESK-APAC')

and

If(GetFieldSelections([IM Submitter RA])='GSK-SERVICEDESK', '<> GSK-SERVICEDESK', 'GSK-SERVICEDESK')

1 Solution

Accepted Solutions
Highlighted

Not sure understand properly.

May be like this?

Add Two "Toggle Select" Actions.

Put the Same Field in the both with different values.

like the below

1.JPG

2.JPG

View solution in original post

4 Replies
Highlighted

I am not entirely sure I understand what you are trying to do... would you be able to share a mocked up sample to show what you have and what you are looking to do?

Highlighted
Creator
Creator

I can't really share the app at the moment.  However, what I'm trying to do is pretty simple.

In my data I have many different values in a column called IM Submitter RA.  I'm trying to create a button that toggles between all values in the IM Submitter RA column and 2 specific values ('GSK-SERVICEDESK-APAC' and 'GSK-SERVICEDESK').

I have the following code working but for only 1 RA.

=If(GetFieldSelections([IM Submitter RA])='GSK-SERVICEDESK-APAC', '<> GSK-SERVICEDESK-APAC', 'GSK-SERVICEDESK-APAC')

I'm looking for code where I can toggle between selecting two values in the same column or all values in the column.

Highlighted

Not sure understand properly.

May be like this?

Add Two "Toggle Select" Actions.

Put the Same Field in the both with different values.

like the below

1.JPG

2.JPG

View solution in original post

Highlighted
Master II
Master II

One way is as below:

For your toggle button you can add a select in field like below: (vToggle is a variable)

Select in Field:

Field:

      Country

Search String:

     =If(vToggle=1,'("Europe"|"America")','*')

The above code, on one click it will select the data for Europe and America and the other click it selects all the data for a particular column. Hope this helps..