Missing Manual - GetFieldSelections() + Bonus Example

[robert_mika]

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

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

[#2]

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

[robert_mika]

Thanks for sharing Kiran.

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

[isorinrusu]

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.

[robert_mika]

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.

[#6]

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?

[datanibbler]

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!

[#8]

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

[Colin-Albert]

Another good post Robert.

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

[robert_mika]

Thank you Colin.

Appreciate your comment.

[#11]

Thanks for the clear explanation!

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