topic getCurrentSelections in QlikView

getCurrentSelections

ali_hijazi — Thu, 10 Sep 2015 10:18:49 GMT

Hello

I know that the function getCurrentSelections gives the names of the fields with the selected values

and if Clear is clicked this function will return null

is there a way to check that there is selection on all fields except for some specific fields

I want to check if the user at least selected any value of any column in the schema but ignore selections made on some specific fields

is this possible ?

Please advise

Re: getCurrentSelections

marcus_sommer — Thu, 10 Sep 2015 11:59:55 GMT

You could use various string-functions like subfield(), index(), (wild)match() to search within the getcurrentselections-result but I think to use multiple getfieldselections() or getselectedcount() queries will be easier.

Another possibility might be to use a count-function with some conditions over alle your needed fields and values maybe like: count({< Field1 = {'Value1'}, Field2 = {'Value2', 'Value3'} >} Field1&Field2) which returned a value >=1 = true or 0 = false.

- Marcus

Re: getCurrentSelections

johanlindell — Thu, 10 Sep 2015 12:20:37 GMT

Well, it is definately possible.

This formula should do the trick:

=$(='RangeSum(' & Concat ({<[$Field] =- {'My exclude field 1', 'My exclude field 2'}>} 'GetSelectedCount([' & [$Field] & '])', ', ') & ')')

If you want to show the formula in text you can paste this into a text box:

='RangeSum(' & Concat ({<[$Field] =- {'My exclude field 1', 'My exclude field 2'}>} 'GetSelectedCount([' & [$Field] & '])', ', ') & ')'

It creates a dynamic expression using the hidden field for all fields, $Field and uses Set Expression to exclude certain fields. Example

=RangeSum(GetSelectedCount([History]), GetSelectedCount([Issues]), GetSelectedCount([ToDo]))

Re: getCurrentSelections

ali_hijazi — Thu, 10 Sep 2015 14:28:14 GMT

thank you