Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Esteemed Contributor II

Re: Field selections

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))

4 Replies
vinieme12
Esteemed Contributor II

Re: Field selections

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

vinieme12
Esteemed Contributor II

Re: Field selections

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))

Re: Field selections

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

Re: Field selections

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

Community Browser