Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Field selections

Hi,

How can I check if a user selected anything other than a specific list of values?

For example, I have the field "Possible Selections" with the values ValueA, ValueB, ValueC, ValueD, ValueE, ValueF.

If the user selects any values different than ValueA, ValueC or ValueF, I want to know.

any ideas?

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

Try this if you want to see values other than specified are selected

=concat(distinct

  if(wildmatch(FIELDNAME,'valueA','ValueB','valueC')=0,AU_TierGroup),', ')

To see count of values selected other than specified

=sum(

  if(wildmatch(FIELDNAME,'valueA','ValueB','valueC')=0,1))

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

4 Replies
vinieme12
Champion III
Champion III

do you want to retrieve the values selected other than ValueA, ValueC or ValueF or just a boolean result?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

Try this if you want to see values other than specified are selected

=concat(distinct

  if(wildmatch(FIELDNAME,'valueA','ValueB','valueC')=0,AU_TierGroup),', ')

To see count of values selected other than specified

=sum(

  if(wildmatch(FIELDNAME,'valueA','ValueB','valueC')=0,1))

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
marcus_sommer

I think you will need to use the audit-logging (could be enabled within the qmc) to track which user did what (inclusive selections) within an application. If you are dealing with confidential data and you need to control the access on the data on the user-level you should consider the use of Section Access.

- Marcus

Not applicable
Author

I need the count result. Thanks!!! it works great!