topic Re: Set Analysis Based on Selection in QlikView

Set Analysis Based on Selection

evansabres — Thu, 25 May 2017 14:36:35 GMT

Is it possible to have a set analysis expression that is based on a selection in a table?

=COUNT({$<Author={"Criteria From Selection"},}>}[Author])

sibusiso90 — Thu, 25 May 2017 14:43:26 GMT

Yes you can.

here are examples below from the qlik reference guide

Synchronizing Selections between States

Example:

The following expressions can be used in a single chart:

count({$} DISTINCT [Invoice Number])

count({State1} DISTINCT [Invoice Number])

count({State2} DISTINCT [Invoice Number])

There is a problem with this method; the QlikView Developer must duplicate the selections (list boxes and

multi boxes) for all three states so that the end-user can make appropriate selections for the various states. In

many situations the QlikView Developer will want to have a set of ‘common’ selections available to all

states. This will allow the end user to set the context for the various charts and then make use of specific

selections to show the differences between states. Set Analysis can be used with states to keep certain selections

consistent between states.

Example:

count({State1<Year = $::Year, Month = $::Month>} DISTINCT [Invoice Number])

count({State2<Year = $::Year, Month = $::Month>} DISTINCT [Invoice Number])

The QliKView Developer will keep the Year and Month selections in State1 and State2 synchronized

with the Year and Month selections in the default state. The QlikView Developer can add

elements to the set modifiers as necessary in order to keep even more fields consistent between states.

Kind Regards

Sibusiso Phumelo

Anonymous — Thu, 25 May 2017 14:45:27 GMT

Hello Evan,

Try this:

=COUNT({$<Author={$(=GetFieldSelections([Yours_Field]))}>}[Author])

Yours_Field - change that name on yours

Regards

Jacek.

evansabres — Thu, 25 May 2017 15:02:02 GMT

Unfortunately, I could not get this to generate any results, however may be due to how my data is established.

Anonymous — Thu, 25 May 2017 15:05:54 GMT

Could you send a sample of your data?

evansabres — Thu, 25 May 2017 15:07:35 GMT

I think my data structure is flawed, will revisit that before I move on

praveen_prithiviraj — Thu, 25 May 2017 15:21:39 GMT

=COUNT({$<Author={"Criteria From Selection"}>}[Author])