article Missing Manual - GetFieldSelections() + Bonus Example in Member Articles

Missing Manual - GetFieldSelections() + Bonus Example

robert_mika — Mon, 02 Mar 2015 14:55:50 GMT

Have you ever wondered how the examples from the Qlikview help may look like?

Please see below and enjoy responsibly...

GetFieldSelections()

Definition:

Returns a string with the current selections in a field.

valueSep - is the separator to be put between field values. The default is ', '.

max_values - is the maximum number of field values to be individually listed.

When a larger number of values is selected the format 'x of y values' will be used instead.

The default is 6.

Preparation:

Script to play with:

Load * Inline

[

Year

2007

2008

2009

2010

2011

2012

2013

2014

2015

2016

]

Example 1:

GetFieldSelections(Year )

Our field Year has 10 values (Years from 2007 to 2016)

The default separator is ',' (coma)

The maximum default numbers of values is 6

We used the same expression for all 3 sets of data

Left: Selection of 6 values

Middle: When more that 6 values the result will change to show the values which are not selected.

Right: Selecting whole sets of values will return 'ALL' as result

Data

Expression and Results

Example 2: valueSep

We can assign here any character (or string).

Examples 3: max_values

The default values of 6 is overwritten by the value we have specified(10)

Interesting:

When playing with this function somehow I managed to get result like below

If you can replicate it please post it.

Bonus:

Practical use:

PROBLEM OF DIFFERENCE OF SUM

Still feeling hungry?

How to use - Only()

Do you Qualify?- How to use QUALIFY statement

How to use - Dimensionality()

Missing Manual - GetFieldSelections() + Bonus Example

MaxString & MinString - How to + examples

The second dimension... or how to use secondarydimensionality()

How to use - MissingCount()

How to use- Dual()

Expression Scene Investigation, E1: Moving Average

Re: Missing Manual - GetFieldSelections() + Bonus Example

Thu, 05 Mar 2015 06:25:25 GMT

Hello Robert,

Really interesting post!!

I tried to achieve below scenario & found the following thing:

The above result is possible when your default 'max_values' parameter has value less than your selected number of values.

Regards

Kiran

Re: Missing Manual - GetFieldSelections() + Bonus Example

robert_mika — Thu, 05 Mar 2015 06:41:58 GMT

Thanks for sharing Kiran.

This was my initial thought but I was not able to replicate this result.

Re: Missing Manual - GetFieldSelections() + Bonus Example

isorinrusu — Fri, 06 Mar 2015 10:03:40 GMT

Thanks for sharing!

It seems like from SR9 (at least) there is a new field: state_name. According to the documentation, an Alternate State must be specified, and therefore it returns the field selections applied to that Alternate State.

Regards,

Sorin.

Re: Missing Manual - GetFieldSelections() + Bonus Example

robert_mika — Fri, 06 Mar 2015 10:57:16 GMT

Thank you Sorin for updated.

I have created this document on SR2.

It looks like something has been changed.

This tell me to include version number with each document.

Re: Missing Manual - GetFieldSelections() + Bonus Example

Mon, 09 Mar 2015 14:10:32 GMT

Robert, I used the following =GetFieldSelections([FieldName], '~', 1) and it returns 1 selection, 1 NOT selected, ALL or # of #.

SR5 where Alternate State is a drop-down option in Text Box rather than built into the function.

P.S. Would more control be possible if GetSelectedCount and GetAlternativeCount were used?

Re: Missing Manual - GetFieldSelections() + Bonus Example

datanibbler — Mon, 09 Mar 2015 14:43:57 GMT

Using GetselectedCount() and GetAlternativeCount(), you could build a string like >> selected 6 of 10 << or >> selected: all but 4 << or whatever - or you could fix the below dilemma by hard-coding the treshold.

I don't quite understand - I have experimented a bit with different max_value parameters (I had this exact list of 10 years for an example) and I don't quite understand when exactly the output switches from "4 of 10" or "5 of 10" to "NOT ..."

=> Both happen when there are more selected values than the max_value_parameter, but I don't see the pattern ...

=> Can anyone explain the logic behind this?

Thanks a lot!

Re: Missing Manual - GetFieldSelections() + Bonus Example

Tue, 10 Mar 2015 06:03:12 GMT

Hi DataNibbler,

To be precise about your query, it all depends on value pass in the parameter 'max_value' & number of selection/s made in the field.

If you suppose let set this threshold to 4 for e.g.. then for your any 4 selections, you will get output as selected values. henceforth, you find output as '# of #" in case of more values selected.After that as soon as count of unselected value equal to or less than threshold value (4 in this case) you will get output in the format 'NOT...'

This is what I understood when testing on the different scenario.

Kindly share,if any one find more details on this.

Regards

Kiran

Re: Missing Manual - GetFieldSelections() + Bonus Example

Colin-Albert — Wed, 18 Mar 2015 19:48:07 GMT

Another good post Robert.

These are worthwhile as many of the examples in the help file are very sparse.

Re: Missing Manual - GetFieldSelections() + Bonus Example

robert_mika — Wed, 18 Mar 2015 20:13:46 GMT

Thank you Colin.

Appreciate your comment.

Re: Missing Manual - GetFieldSelections() + Bonus Example

Wed, 16 Dec 2015 15:13:07 GMT

Thanks for the clear explanation!

Does anyone know if it's possible to avoid getting output in the format 'NOT...'?

Re: Missing Manual - GetFieldSelections() + Bonus Example

Thu, 17 Dec 2015 04:50:18 GMT

Hello David,

If you want to show all selected values, then you can create a variable & pass it at 'max_values' parameter.

Like e.g. in this case, LET vYearCount = Count(Year),

then in expression, =GetFieldSelections(Year,'~',vYearCount) will do the purpose.

Regards

Kiran Shinde

Re: Missing Manual - GetFieldSelections() + Bonus Example

Thu, 17 Dec 2015 07:44:08 GMT

Thanks for the fast respons Kiran,

To avoid an unreadable title, I would like to have a max_value that is below the total amount of possible values. The output "x OF y" is very welcome, I just would like to keep that output instead of it switching to the "NOT"-notation.

Re: Missing Manual - GetFieldSelections() + Bonus Example

Anonymous — Sat, 08 Oct 2016 03:51:19 GMT

Thank you Robert Mika, Nice examples.

Re: Missing Manual - GetFieldSelections() + Bonus Example

ecolomer — Sat, 08 Oct 2016 06:21:48 GMT

Good post

Thank's for sharing

Saludos,

Enrique