topic Re: "Explicit" select in field in QlikView

"Explicit" select in field

tinkerz1 — Mon, 24 Aug 2015 12:47:46 GMT

Hi,

Is there a way to set up a button that only selects (colours green) when all the "select in field" parameters are met.

For instance in my example, I have 3 actions on State 1, they are all true and colour green.

But on State 2's Actions the selection France is not true, Mr B does not have product sales in Holland.

Is there a way not to trigger all of the selections if one of the selections is not true?

Thanks,

Neil.

Re: "Explicit" select in field

marcus_sommer — Mon, 24 Aug 2015 13:05:32 GMT

This should be possible within if-loops which queries per getfieldselections() or getcurrentselections() the selections and which have since one of the recent service releases a fourth parameter for the state.

- Marcus

Re: "Explicit" select in field

Mon, 24 Aug 2015 13:19:37 GMT

Hi. In this case, set the last field on the list for the second button. Terms and conditions contradict each other.

Re: "Explicit" select in field

tinkerz1 — Mon, 24 Aug 2015 13:29:46 GMT

I dont understand how both of these comments relates to a button?

Re: "Explicit" select in field

marcus_sommer — Mon, 24 Aug 2015 13:34:08 GMT

If you want to select anything with a button you will need to define an action with a value or a search-string to your desired field(s).

- Marcus

Re: "Explicit" select in field

Mon, 24 Aug 2015 13:39:36 GMT

OK.

You set the three fields. The first field is contrary to the installation of a third field. Runs the last installation for a third field.

Re: "Explicit" select in field

Mon, 24 Aug 2015 13:44:03 GMT

The value for the first field is contrary to the value of a third field. In this case will be set to for a third field.

Re: "Explicit" select in field

tinkerz1 — Mon, 24 Aug 2015 14:04:03 GMT

I think its confusing for and end user to press a button and some selections turn green but not all but a pivot table can produce an output on partial selections.

Re: "Explicit" select in field

ChiragPradhan — Mon, 24 Aug 2015 14:09:15 GMT

Use this for each action on State2 button.

=if(Count({<Salesperson={'Mr B'}, Product={'Product 2'}, Country={'Holland'}>} Salesperson) > 0, 'Holland')

Re: "Explicit" select in field

marcus_sommer — Mon, 24 Aug 2015 14:15:16 GMT

Exactly this is the reason why the use of alternate states or set analysis is difficult for users - you need to explain quite clearly what is happens and why if the select some values and the objects react not like expected. Therefore you should it only use if you it really need and no other way is possible.

- Marcus

Re: "Explicit" select in field

tinkerz1 — Mon, 24 Aug 2015 14:18:58 GMT

Do I place this in the 'Search String' box under 'Select in field'?

Re: "Explicit" select in field

ChiragPradhan — Mon, 24 Aug 2015 14:21:35 GMT

yes, for each action.

And I agree with Marcus_Sommer‌. From a user experience perspective, the end user may not know why certain selections are not being applied. You will probably need to handle is more gracefully unless you have specific requirements.

Re: "Explicit" select in field

marcus_sommer — Mon, 24 Aug 2015 14:23:47 GMT

You placed it within the action under the place for the fieldname. See also here for search-strings: The Search String.

- Marcus

Re: "Explicit" select in field

tinkerz1 — Mon, 24 Aug 2015 14:34:27 GMT

OK great thats much clearer, know I understand how to use expression boxes, i was just typing in literal answers not dynamic answers.

Re: "Explicit" select in field

ChiragPradhan — Mon, 24 Aug 2015 14:59:32 GMT

could you please mark the question as answered