topic Re: Determine if a user has searched for a specific field in QlikView

Determine if a user has searched for a specific field

kfahri342 — Thu, 29 Mar 2018 11:43:34 GMT

Hi Qlikers,

I have two fields, [ID, NAME]. Can I create an expression, where if a user actively searches for an ID or NAME, I return the value 1 otherwise, it would be 0?

Many Thanks

Kozan

Re: Determine if a user has searched for a specific field

Peter_Cammaert — Thu, 29 Mar 2018 12:10:26 GMT

Using the standard tools in QV Desktop I don't think so.

If you enable the Audit logs on your QlikView server however, you may be able to trace user activity and selected/searched values.

Re: Determine if a user has searched for a specific field

kfahri342 — Thu, 29 Mar 2018 14:33:58 GMT

I don't want to be able to trace there activity. I just want to be able to use this variable in a expression of mine.

Is there an expression that captures if the search for a Name or ID?

Re: Determine if a user has searched for a specific field

marcus_sommer — Thu, 29 Mar 2018 15:01:01 GMT

In many cases it doesn't matter if the user used FieldA and/or FieldB to select certain data because they are "usually" well connected within the datamodel. But you could of course also query if there are any or certain selections with functions like: getselectedcount/getfieldselections/getcurrentselections() and then react on them.

- Marcus