topic Re: Select in Field where Search String not Present in QlikView

Select in Field where Search String not Present

Wed, 25 Nov 2020 16:16:04 GMT

Hey -

Ive seen this question asked several different ways but never can find a clear answer.

The situation I am having is that I have a Button in which I would like to Select in Fiels a specific "Inventory" within a set of data. The possible Inventory selections are A, B, C, D.

Inventory D is a very rare Inventory and usually only shows up about once a year; howver, all of these Inventory selections are checked on a monthly basis.

When I create a Button to Select in Field Inventory D and its not there for most months within my Table Box data and Chart Box it displays all other Inventory selections A, B, and C since again D is not available most months.

My question being; How can I set my Button to only show selections for Inventory D and when Inventory D is not available it will show blank?

Appreciate any assistance, Thanks!

Re: Select in Field where Search String not Present

rubenmarin — Tue, 29 Nov 2016 15:42:12 GMT

Hi Dylan, not fully understand your requirements, if it helps you can check if inventory 'D' is in the possible values with:

Index(concat(distinct Inventario, ','), 'D') //Will return true if 'D' is in the possible values of Inventory

Re: Select in Field where Search String not Present

Gysbert_Wassenaar — Tue, 29 Nov 2016 15:43:09 GMT

You can try adding a calculation condition to your table box: =count({$<Inventory={'D'}>} Inventory)

Re: Select in Field where Search String not Present

Wed, 30 Nov 2016 21:34:43 GMT

Hi -

I believe this is on the right path of what I am trying to accomplish.

However, upon button selection I am wanting the chart/tablebox to return null or blank if the selection ("D") is not present; instead it returns everything (A,B,C).

Re: Select in Field where Search String not Present

rubenmarin — Thu, 01 Dec 2016 11:38:06 GMT

Hi Dylan, a sample will be nice to fully understand the behaviour. I can say that: if you have a field with a selected value and you execute an action to salect a value that doesn't exists in the field, it removes selections on the field, this seems related to what you see: the value doesn't exists -> selections on the field are removed -> you see all inventories.

You can use an expression to check if there are more than one possible inventory, and in this case hide (Design tab -> conditional show) or show a message (General tab -> Calculation condition) ('Messages...' button to customize messages).

The expression can be:

Count(DISTINCT Inventory)=1 // If there is only one inventory selected show/calculate the chart

Re: Select in Field where Search String not Present

Wed, 07 Dec 2016 03:37:33 GMT

Took me a few to get back to this;

I was able to utilize the Geneal Tab > Calculated condition with the below to "grey" out the button when the Inventory Selection of "D" is not available; which is perfect for what I am looking to do. Thanks!

=count({<INVENTORY={'D'}>}INVENTORY)