Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am always learning something new when it comes to Qlik products. This week, while working with a colleague, I learned about the sheet action “select values matching search criteria” that I had never used before, so I decided to blog about it. I have used sheet actions in the past to clear selections or to select a bookmark when navigating to a sheet, but this sheet action performs a search to make selections. My colleague needed to make a series of selections to include and exclude data based on specific criteria. Using this sheet action, he was able to execute a complex expression to make selections on a sheet saving the users time when they navigate to that sheet.
Up to five actions can be added and they will run in the order they are listed. Sheet actions can be added from the Properties panel of a sheet. In this example, I have 3 actions.
In the first action, I am selecting quantities greater than 100. Notice in the Quantity > 100 action that single quotes are required when using an expression for the search criteria. It is possible for an action to deselect a previous action. For example, the first action selects 110, 120, 130 and 150 from the Quantity field. Then, in the second action, Babywear is selected from the CategoryName field, deselecting 110, 130 and 150 from the Quantity field. The last action selects 2021 from the Year field which deselects Babywear. So once all the actions are performed, these are the selections made.
Here is a list of all the sheet actions that are available:
Most of these are very straightforward but you can find more details on sheet actions in Qlik Help. Some important things to note:
With the “select values matching search criteria” sheet action, you can use an expression or simply a value to search for and make selections in a specified field. This can be useful if you have a sheet in your app designed to perform a specific analysis that requires some selections to be made to begin. Using an action makes it easier for the user to get started and leaves little room for error by forgetting to make needed selections. I love that I am always learning something new with Qlik. Try out sheet actions in your app to automatically apply selections.
Thanks,
Jennell
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.