topic Re: Search Function in QlikView

Search Function

kfahri342 — Thu, 22 Mar 2018 10:20:05 GMT

Hi Qlikers,

I am hoping the following is possible.

Status	Name	ID
Complete	Name1	1234
In Progress	Name2	5678
N/A	Name3	9012

I have a dashboard with a table for each status that list the names in each category. The user has the option to select a variety of buttons to make the "Complete, In Progress or N/A" table to appear (only one table can be shown at all times).

The user has a search bar if they wish to search for a specific name or id.

Is there a way, to indicate to the user [my thought was a red dot in the corner of each button] to signify which table to refer too to find details about that certain Name or ID.?

e.g user searches for Name2, a red dot appears in the "In Progress" button. Signifying to the user that the item can be found there.

I am dealing with 5000+ data items, so a code that suits this would be most appreciated

Many Thanks

Re: Search Function

swuehl — Thu, 22 Mar 2018 10:43:16 GMT

If you refer to 'searches for Name2', you mean the user makes an active selection of Name2 in field Name?

If so, you can create a conditional like

=If( Count({<Status *= {'Complete'}>} Status), ...)

and use this e.g. in the background color expression of your Complete button (adapt status values accordingly for other buttons and charts).

Re: Search Function

kfahri342 — Thu, 22 Mar 2018 11:25:54 GMT

Yes the user will actively search for name/id.

I tried your condition however, I keep getting and "Error in expression" message. Are you able to advise?

Thanks

Re: Search Function

swuehl — Thu, 22 Mar 2018 12:52:12 GMT

Ok, where exactly have you put the conditional expression and how does it look like?

Can you post a small sample QVW or screen shots?