Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
shekhar_analyti
Specialist
Specialist

Action based selection of all value except one . How to achieve ?

Hi All ,

Action based selection of all value except one . How to achieve ?

Let say there is a field Company ; whose distinct values keeps updating on daily basis .

Company

A

B

C

D

E

F

....

..........

What i needed was , when user presses a ACTION BUTTON , all values except C should be selected in Company field for 1st time , if the same button is selected for second time , it should return to normal state .


Thanks & Regards

Shekar

1 Solution

Accepted Solutions
sunny_talwar

Try this...

=If(GetSelectedCount(Company) = 0, '(* ^ C)')

Used Stefan's response from the comment section here

Compound Search - demystified

View solution in original post

4 Replies
shekhar_analyti
Specialist
Specialist
Author

stalwar1

Hi Sunny Bhai . Help Needed !!

m_woolf
Master II
Master II

Can be done with two buttons and a Conditional Show:

First button visible when vToggle = No

Actions to select all but one value:

     First action: Select in Field Company, Select value C

     Second Action: Select Excluded

     Third action Set Variable vToggle = Yes

Second button visible when vToggle = Yes

Actions:

     First Action: Clear Field Company

     Second action: Set variable vToggle = No

sunny_talwar

Try this...

=If(GetSelectedCount(Company) = 0, '(* ^ C)')

Used Stefan's response from the comment section here

Compound Search - demystified

shekhar_analyti
Specialist
Specialist
Author

Thank you Bhai ..