topic Re: Selecting multiple field values by selecting specified one field value. in QlikView

Selecting multiple field values by selecting specified one field value.

abhi1693r — Sat, 16 Nov 2024 03:09:24 GMT

Hi,

So I have made a multi-box with a field 'A' having three levels 1, 2 and 3. Now as multi-box works, I can filter the data by selecting 1,2 or 3 or a combination of these levels. My requirement is that if someone selects 2, 1 should automatically be selected and if someone selects 3, 1 and 2 should be auto selected. Is this possible?

Re: Selecting multiple field values by selecting specified one field value.

marcus_sommer — Fri, 28 Jun 2019 08:43:55 GMT

Personally I would rather try to avoid such selection-actions and implement the task with set analysis within the expressions, for example with something like:

sum({< Field = {"<=$(=max(Field))"}>} Value)

IMO even better would be the users select really all values which they want to see. It's not difficult and belonged to the basics of the Qlik usage (and principally to each BI tool) and has far more benefits as disadvantages, see for it: Let-the-User-Select .

- Marcus

Re: Selecting multiple field values by selecting specified one field value.

abhi1693r — Fri, 28 Jun 2019 13:33:48 GMT

Hey Marcus,

I am new to Qlikview. Didn't really understand the solution, sum({< Field = {"<=$(=max(Field))"}>} Value). Can you put it in context to my problem and also where to write it.

Re: Selecting multiple field values by selecting specified one field value.

marcus_sommer — Fri, 28 Jun 2019 13:41:16 GMT

Just replace Field with your field - above you called it A - this means then:

sum({< A = {"<=$(=max(A))"}>} Value)

- Marcus

Re: Selecting multiple field values by selecting specified one field value.

abhi1693r — Fri, 28 Jun 2019 14:10:49 GMT

Doesn't work. Value term is not getting recognized.

Re: Selecting multiple field values by selecting specified one field value.

marcus_sommer — Fri, 28 Jun 2019 14:34:15 GMT

You need to replace Value, too with those fields which you want to measure (and also replacing the sum() with count() or avg() or whatever you need).

- Marcus

Re: Selecting multiple field values by selecting specified one field value.

abhi1693r — Fri, 28 Jun 2019 16:27:48 GMT

This solution is actually aggregating values; My problem lies with selecting a value automatically when another specific value is chosen.

Re: Selecting multiple field values by selecting specified one field value.

marcus_sommer — Sat, 29 Jun 2019 08:31:02 GMT

That was the aim of my suggestion - to transfer the selections into the expressions (you could regard a set analysis as a selection).

Like above mentioned is a native and direct selection from the users the easiest way either in the development of an application and also in the navigation & usability of the users. If there are reasons to decouple the user interactions from the results the use of a set analysis is usually the best choice and you should to make it clear for the users what behaved differently and why. The usage of a lot of magic with actions and macros is far more critically - just read the provided link from above carefully.

Nevertheless if you want to apply an automatic selection go to the document properties in tab triggers, choose your field A and add there as search-expression: <=$(=max(A))

- Marcus

Re: Selecting multiple field values by selecting specified one field value.

abhi1693r — Mon, 01 Jul 2019 15:41:58 GMT

The expression is not working (<=$(=max(A))). Is this specifically for Qliksense?

Re: Selecting multiple field values by selecting specified one field value.

marcus_sommer — Tue, 02 Jul 2019 07:01:30 GMT

It shouldn't be: (<=$(=max(A))) else <=$(=max(A)) or ="<=$(=max(A))" or "<=$(=max(A))"

- Marcus