topic Re: Field selections in QlikView

Field selections

Sun, 07 Aug 2016 07:10:30 GMT

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?

Re: Field selections

vinieme12 — Sun, 07 Aug 2016 13:37:24 GMT

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

Re: Field selections

vinieme12 — Sun, 07 Aug 2016 13:45:30 GMT

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

marcus_sommer — Sun, 07 Aug 2016 13:45:54 GMT

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

Re: Field selections

Mon, 08 Aug 2016 10:52:04 GMT

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