White cells represent optional field values. The user can select several KPI's with fieldname KPI_Description. - chart function. GetFieldSelections, GetPossibleCount will not take parameter as Alternative states. Check attached document for solution. I read the help page of (click here) GetFieldSelections; it returns the selection made on a field (any field in the data model); you are passing an expression to the function, so it does not know what to do with it. Count >0 then. fldVal. What I want is two columns in a straight table, the first showing the values from the selected year from a listbox populated from the master calendar. This will always return exactly one value. Maxvalues is the maximum number of field values to be individually listed. date. If all but two, or all but one of the values are selected, the format 'NOT x,y' or 'NOT y' will be used. Name values should be displayed according to the language but the for each language there are multiple names (possible values) and the. Hi, I need to create an expression in a dimension that when one vale is selected, it will exclude the field of another dimension. 0. The list object contains one field (. Any help is appreciated. Obrigado. 3. This should work I think: =If ( Match ( logmonth , $ (=Chr (39) & GetFieldSelections (DueMonth, Chr (39)&','&Chr (39), 12) & Chr (39) ) ), logmonth ) The entire expression between $ ( and the next to last ) will be evaluated and the result will be put into the outer expression. Clear the selections in all fields except the current field; Clear the selections in a visualization; Clear the selections of a specific field; Enter and exit the selection mode; Get the current selections; Invert the current selections; Select all possible values of a field; Select all possible values of a list object; Select all values of a fieldClear the selections in all fields except the current field; Clear the selections in a visualization; Clear the selections of a specific field; Enter and exit the selection mode; Get the current selections; Invert the current selections; Select all possible values of a field; Select all possible values of a list object; Select all values of a fieldYou can search selection items in the selection bar, and within visualizations such as filter panes and tables. functions. Click Edit sheet. If the selections are instead made using a search string in a search box, GetCurrentSelections () returns the search string. fld. Array of qFieldValues to select. 3. Arguments: Arguments. Clear the selections in all fields except the current field; Clear the selections in a visualization; Clear the selections of a specific field; Enter and exit the selection mode; Get the current selections; Invert the current selections; Select all possible values of a field; Select all possible values of a list object; Select all values of a fieldIn response to Anonymous. Or if it's several values you can use. I tried with/without '2022', but still didn't work. . On dashboard user was given only field option to select values which is Language. GaryHi, I need to create a filter that will be able to select options within a list. 2. fldVal (0). GetFieldSelections()returns a stringwith the current selections in a field. I mean, if I want to know which is the last sales month I need to click on AsOfYear = '2010' ( Year field of the Rolling Months Table) and Year ='2010' (Year Field of Regular Calendar Table). If you type New in the filter pane and hit enter, all the cities that match this term are selected like New York City, New Delhi. Note: when I use the variable, field names are within single quotes. But if there are way to many fields, you can work with GetCurrentSelections and use the max_values to make sure that you see all the values. The list object has one dimension (. We would like to show you a description here but the site won’t allow us. expression. I found the solution and want to present it to whomever it might find useful: First set up a dynamic variable which reads in the selection from Field A in alternate stat 1 with GetFieldSelection (): Next, whenever a selection on Field A is made it should trigger the following: Martin. 3. created by sebastiao fogaça in Qlik Brasil - View the full discussion. Total. The date range picker (Date picker) lets you select a single date or a range of dates from a calendar. (I don't use qlik on an everyday basis. or. WriteLine("Field: " + selectedField. Estou utilizando a função GetFieldSelections, ex: "GetFieldSelections(SETOR)"Posted the app too. Currently this is the formula I am using : 'Q'&ceil (Month (QuarterStart (max (FDAY),-1))/3) which is not. GetPossibleCount () is used to find the number of possible values in the identified field. Select "13". All About Selections. the "Selections" screen or smart search or current selections, they will be able to select multiple values or no values at all. Using GetFieldSelections (KPI_Description) I get Margin. If I select less values say 2005-2008, GetFieldSelections(Year) will return all the years with , delimited. Type the name of the field for the selection in the Field box. Thanks Sunny_talwar, your second solution makes sense. I'm thinking that if the date doesn't exist, then nothing gets selected. Date 2 (Closed Date) Date (selected date in UI) Status. If Change=+10 and Month='Aug', The [Value] for Aug increases by 10%. There are couple of methods: 1. filter. 2020-07-30 04:34 AM. field("English short name"). Thank you so much in advance. Never really looked how the sorting happens within getfieldselections () and I rather doubt that there are possibilities to adjust the behaviour. 1 Solution. If options are used, you will need to specify record_sep. Please guide on the same. LowLevelSelect if you know the index. get possible values from the field selection. Here i need to exclude that salesperson in this chart footer as this is not applicable. You can do it within the expressions, but it makes more sense to fix it on the script level. Referencing Alternate States in GetFieldSelections. If options are used, you will need to specify record_sep. chart. GetFieldSelections () returns a string with the current selections in a field. To specify a new line set record_sep to chr (13)&chr (10). In the button properties, go to the "Actions" tab and click "Add". PS: Mark this post as solution, to avoid others spending time on your post to answer it. It should work for single values however if you select over 80% of the possible values it will return a 'NOT ValueX, ValueY' which won't work in Set Expression. If you have locked a selection and then try to select excluded field values, the selection item will flash to indicate that the locked selection prevents the selection from being made. Qlik Sense; Qlik AutoML; QlikView; Qlik Replicate; Qlik Compose for Data Lakes;This is an expressions which Sums the measure (field) Sales - where the YearMonth dimension (field) equals today's month and today's year - they are formatted and concatenated basically to match the value in the data. The default is ': '. The Qlik Cloud connector has the following blocks which can be used for selections: • Select Field Value This block performs a selection. Get started with analytics in Qlik Sense; Administer Qlik Cloud Analytics Standard. 5. I have an Stored procedure in My SQL Server which I want to execute in Qlikview , I need to pass the value to the stored procedure by selecting on the field in Qlikview upon which I need to reload the data to get the values returned by the proc. Set Analysis Get Field Selection. The concat function will result in 'value1','value2'. Wildcard searchWhen you search data, the results show the combinations of matches found in the entire Qlik Sense database. All values of the field City are selected while only the first value is selected in the field Country. But if department A is selected then the average sale changes to 8$ because there are only 125 with sales in the period. If the user selects a year, this will return the selected year. CountriesFilter: =Concat (DISTINCT chr (39)&CountryToLoad&chr (39),',') In this way, I can select multiple values of the Country field based on another field without being even connected. so i will try to post here and i hope to have answer My input file is Excel. When you search data, the results show the combinations of matches found in the entire Qlik Sense database. Specialist. Get started with analytics in Qlik Sense; Administer Qlik Cloud Analytics Standard; Administer Qlik Cloud Analytics Premium and Enterprise;. Where Date is the date-format field and Master_Month is one of the Master Items defined as =Month(Date) I just want to ignore the selection in Master_Month field, but QS is ignoring this option. These functions can only be used in chart expressions. 2022-09-12 07:41 PM. How can i make it, that if i s. Thank you Sokkorn and Kumar! Yes I want to distinct the result too. Selecting Field Values. The user should use the calendar object to select a desired date and then click the button to apply the filters. =GetFieldSelections (FIELD,';',1) 1 Solution. I have a button against which I wish to Add an Action to Toggle the Field Selection of the field Product Code so that it filters by codes 751675, 753399, and 892964 (or removes them when toggled off again). GetFieldselections not working with AND Condition with different dimensions =If(GetFieldSelections(Crop)='Tomato' and GetFieldSelections(Species)='Tomato',1,0) Field functions. 1. GetCurrentSelections() returns a list of the current selections in the app. It just not able to recognize this field name. The problem arises when I select two or more date in the filter box: the if function finds no corresponding value. 2018 16:00 2 10 10 20 3. The selection may affect the states of a large number of values in the other sheet objects, on the current sheet as well as on other sheets. In the Current Selections window, selections are listed by field name and field value. Just fyi, I managed to make it work with something like this in the NPrinting filter: =match (Country,$ (vNP. These functions can only be used in chart expressions. i need that possible values of one Field will be selected in another Field. If you have more than six selections in a field the total count will be off. If all but two, or all but one of the values are selected, the format ' NOT x,y ' or ' NOT y ' will be used respectively. Reply. The last step is to check the layout of the list object in order to see the selected values. Select "Select in Field" as the action type. If options are used, you will need to specify record_sep. Regards, Sergey. I add the field year in the expression of the calculated dimension YEAR : = If (Year = salesYear and Year = priceYear and Year = Year, Year) When I select 2015 in the calculated dimension, The three other take automaticly the same value: But I agree with other, that it would be better to use only one field Year in. New to Qlik Sense; Move to SaaS; Alerting; App Development; Data Integration. Text search is the main search method you can use in Qlik Sense. To specify a new line, set record_sep to chr (13)&chr (10). It's possible that all - 1979991. Clear the selections in all fields except the current field; Clear the selections in a visualization; Clear the selections of a specific field; Enter and exit the selection mode; Get the current selections; Invert the current selections; Select all possible values of a field; Select all possible values of a list object; Select all values of a fieldClear the selections in all fields except the current field; Clear the selections in a visualization; Clear the selections of a specific field; Enter and exit the selection mode; Get the current selections; Invert the current selections; Select all possible values of a field; Select all possible values of a list object; Select all values of a field1 Solution. I guess create a KPI object with GetFieldSelections (Ano) to see if it show anything (make sure you set custom format to see the text values, else KPI object might just show -. EndDate. If options are used, you will need to specify record_sep. Selections allow users to explore the data in an app and to answer their specific questions at any given time. Try this: Concat (distinct [Demographics], ',') This will store all selected values in a comma-separated string array. If the load script looks likeCan share an example: I have a field, called Town. Clear the selections in all fields except the current field; Clear the selections in a visualization; Clear the selections of a specific field; Enter and exit the selection mode; Get the current selections; Invert the current selections; Select all possible values of a field; Select all possible values of a list object; Select all values of a fieldThe List box for this field is set to Always one selected. set analysis. SQL EXEC Proc_Name '$ (vSL)','$ (vEL)'; vStartLocation= getFieldSelection. The default is <CR><LF>. I want to put only 1 field into my worksheet to select a year. If you select all values and the count of all values is greater than max_values, the text ALL will be returned. All forum topics. GetCurrentSelections () returns the current selections in the document. We would like to show you a description here but the site won’t allow us. I've set a table to alternate state and want to get in that table the selections from a mainstate table. Hello Everybody, I'm a student, and i'm a newbie. 2018-04-12 12:08 PM if Statement based on possible field selection Hello, I am trying to create an if expression that considers the possibility of a field being selected. It is included in Dashboard bundle. count. Selections bar with the selections Year, Product Group and Region made. Text search can be split up into two separate search modes: Normal search. In this example, the first step is to create a list object which contains one field (the field: Country). In general, GetCurrentSelections () function returns a list of the current selections in the app. Ditto - same here! 1,258 Views 0 Likes Reply. Its working only on select MONTH_N. but the number of fields can be selected is dynamic i. Hi there, I want to exclude 'PVC_date' field from selection. Personally I would prefer using GetFieldSelections () for a limited number of fields, as it might be easy to format. qlikview. É possível??? Necessito saber os meses não selecionados para fazer uma análise diferente. GetFieldSelections () returns a string with the current selections in a field. date. If all but two, or all but one of the values are selected, the format ' NOT x,y ' or ' NOT y ' will be used respectively. 1. If you User select A: then in one KPI should be value 1 and in another 2. As mentioned the getfieldselections () function returns values with a '$ (=GetFieldSelections (BU))' will result in 'value1,value2' which set analysis can't use. GetFieldSelections. This is to only make fields starting with XXXX filterable. 1. GetFieldSelections ( [Main State]:: [Field],',',100000) If I set the selection box also to an alternate state like "State A". Solved: Hi guys! I'm new to QlikView and got a question here: I have a field contain cities: Cities Jakarta New York Melbourne Madrid Tokyo Prague and - 389428. After checking that no values in the field Country are selected, the handle of the field Country is retrieved and some selections are made in the field. hence I was asking for both the conditionsGet field selection expression does not recognize assembled field name Hi, Does any know what the below expression isn't working. Select all the values of the list object. If i test it by this expression the chart shows the correct data:app. 1. Unfortunately this seems to be bound by the qSelectionThreshold which is 6 for some. All About Selections. Getting exactly three values, sorted by an expression, is doable, though if there are ties you may not get the results you expect. In case of multiple selections it is better to use a string array to store selections in a variable. Lauri. In response to CELAMBARASAN. We would like to show you a description here but the site won’t allow us. Solved: Hi guys! I'm new to QlikView and got a question here: I have a field contain cities: Cities Jakarta New York Melbourne Madrid Tokyo Prague and - 389428. Partner - Contributor III 2021-01-13 06:53 AM. Hope this helps you. The goal is to select some values of a field, by entering the values to select. Text search can be split up into two separate search modes: Normal search. Try the following code to get the first values from a field =SubField(Concat(DISTINCT Field, ','), ',', 1) Change the 1 to 2 to get the second value, and so on. GetSheetObject ("Products") valProduct = ProObject. The field is then moved down to App dimensions. Also it does not seems your expression works in getfieldslection condition check once but you deleted the eariler. These fields have no meaning to the application user and so can be confusing if displayed, How do we exclude these fields from the current selection box? Here is what displays. I tried with/without '2022', but still didn't work. The following set statement is successful if I only select ONE value from my Occupation filter: count ( {<Occupation = {"$ (=GetFieldSelections (Occupation,','))"}>}EMPLOYEE_COUNTER) However, if I select more than one value then it can't evaluate. petter. There are no selections. com> escreveu: GetFieldSelections - função para capturar o primeiro valor. . A simplified syntax with strings or numbers also works since. (Name) = Returns no value even if I select Name. Greeting for the day! I have a question that ,How i can get default multiple values selected in qlik sense using climber selection or simple field selection extension. If (_CalendarType = 'Fiscal' , GetFieldSelection ( [Fiscal Year]), $ (vSalesBookUsgae) ). Amigo, Bom dia. I'm using datepicker in my app to make my selections. For example, if my data is: Column Blue, Black, Red Blue Red, Black Black, Red Red I want to be able to create a filter that will select each of the three colors. I have 2 month fields, one is created month and the other is due month. In this. Create a transient list object with the identifier (. Author. When I click this button, I want it to select in Town, the towns that have sum (Sales) >= 80. If you are selecting any date values from any list box then use. The ability to make selections and see what data is associated is one of the powerful capabilities of Qlik Sense and QlikView. This block performs a selection. Dear all, I'd like to have all tables and their fields from an app, there is this piece of code from the Qlik Sense manual (2. Returns a string with the current selections in a field. When a larger number of values is selected the format 'x of y values' will be used instead. Regards,Glad to help. In addition to the fields extracted from the data source, system fields are also produced by. I have created a filter with "Time" as dimension and the possible values that "Time" can assume are: "Year","Month","Week". . qliksense. CountriesFilter)) where vNP. The second column needs to show the values from the. To do this you need to add trigger for the field, I added the trigger for field by doing the following steps. As we are in Aug so the field should get selected with "2021 Q3" automatically when the user log in. If all but two, or all but one, values, are selected, the format ' NOT x,y ' or ' NOT y ' will be used respectively. qlik sense. action2: clear selection in other fields (which should clear all other fields except REP) 3. Instead we can use general functions like Maxstring, Concat, Count functions. - List Values Of Field: Color. ValueSep is the separator to be put between field values. Clear the selections in all fields except the current field; Clear the selections in a visualization; Clear the selections of a specific field; Enter and exit the selection mode; Get the current selections; Invert the current selections; Select all possible values of a field; Select all possible values of a list object; Select all values of a fieldIn response to Anonymous. Dim as DimSelect. But this is not the case when I use the expression above, because the selection on status is fixed to A+B, disregarding the current. In your case you could avoid the commas by using another set analysis syntax like: vState_Group1 = (NJ|MA|CA) Beside this it's much easier to use field-selections instead of variables, for example: < Field = p (Field) >. chart. If Get Current Selection = this, exclude this. You can set the field break positions in two different ways: Manually, enter the field break positions separated by commas in . If you have made a selection in f1, there is only one possible value of f2, one value will be white (possible) in a list box for f2. When I select 'C C' or 'D D', the value is not calculated. Apply selection on Qlik Sense custom extension. In this example, the first step is to create a list object which contains one field (the field: Country). 2018-08-22 11:52 AM. @ioannagr Go to Field->Click on Field to which you want single value selection ->Click Settings-> check "Always one selected values" option. qlik. Another point is the syntax which isn't quite right by multiple values - in this case it should look like: Sum ( {<Year= {$ (=concat (distinct Year-2, ', '))}>}Qty) If it's not working put the concat (distinct Year-2, ', ') directly as parallel expression within a table-chart to see the results which should then give valuable hints what happens. GetFieldSelections, GetPossibleCount will not take parameter as Alternative states. And the. , you can clear a selection in a field by clicking . If options are used, you will need to specify record_sep. Qlik Cloud Platform; Qlik Sense; Qlik AutoML; QlikView; Qlik Replicate; Qlik Compose for Data Lakes; Qlik Compose for Data Warehouse; Qlik Enterprise Manager; Catalog. Do you have some additional information on what it is exactly that you are trying to do? Hi I need to add if then and else condition for a complex query in set analysis of qlikview along with getfield selection in it. Hello, I have a question about ignoring a particular filter selection, Lets say that i have a simple calculated table like this: TimeStamp (Atucalendar driven) ID Value1 Value 2 calculated value 1. : state_name: The name of an alternate state that has been chosen for the. selectMatch(menuCountryName, false); } } I have a drop down list of countries (in jQueryUI) and the user can select a country from the list. 3. If ( [Mat Date] >= Today (), [Mat Date] ) in Dimension. field("English short name"). In GetFieldSelections, when you get above a certain number of selections, it doesn't. For 3 Fields it working as expected but one of the. Note: From help, you can noted that, you can't able to represents both as string value in dual () fuction. Select "Select values in a field" action on the sheet properties and define the field values. In the "Field" dropdown, select the field you want to select values from. Have you tried something like ='Analyse: ' & Only (Year) & ' ' & concat (distinct Month, ' - ' ) 3. I looked at your data model, the field "Flag_MaxSimID" is defined in the table FormsPriceSim, but this table is. Get the current selections by using the GetLayout method on a session object in which qSelectionObjectDef is defined. The data is a Fiscal Year column and if a 2015 value is selected in a filter I need to see only Fiscal Years that are greater than or equal to 2015. But not working. Issue is with the concat part. The field [Change] is a number between -50 to +50. Solved: Hi all, I have a filter with years 2017,2018,2019. in the caption of a list box is an icon, and if you press it , you get a search field for the list box. If you select all values and the count of. Field functions either return integers or strings identifying different aspects of field selections. For example when I select year 2018, I want to be able to compute the count(ID) of the - 1521363List Boxes. The QlikView Classic, Corner Tag and LED styles all use color coding for indication of selected, possible and excluded values. Qlik Community. You can even make use of this code to get all the current selections: var currentSelection = App. It works in Qlik Sense too: I add the field year in the expression of the calculated dimension YEAR : = If(Year = salesYear and Year = priceYear and Year = Year, Year) When I select 2015 in the calculated dimension,. As the user would be generating the on demand app more frequently, user might not be able to understand/track what selections were made to generate each of those on. In my actual data, there are many more values, and there might be a large amount of selections. navigation to another app: ='the target URL'&'/select/' & getcurrentselections ('/select/','/',';') when i press the button i can see in the URL that the first action was applied but the second wasn. sense. I can get the selected value of f1-field through getfieldselections('f1') function. GetCurrentSelections () returns a list of the current selections in the app. Ditto -. I am trying to use the GetFieldSelections with the "Select in Field" Action to Trigger a selection in another Dimension with exactly the same values. Note: when I use the variable, field names are within single quotes. Click a selection item, and in the selection pop-up, type your search string. Also you cannot select multiple values because of the separator being "," but multiple values need to be written as {'X', 'Y', 'Z'}. table. 4. Please see attachments for further details. So, for the 2nd selection you must use Alternate Select, which means add the selection. The default is ', '. 3. qlik sense. I have 2 month fields, one is created month and the other is due month. The Qlik Cloud connector has the following blocks which can be used for selections: • Select Field Value This block performs a selection. In response to. name, but it was not read by GetFieldSelections as a field, but just a text. As mentioned the getfieldselections () function returns values with a '$ (=GetFieldSelections (BU))' will result in 'value1,value2' which set analysis can't use. Not applicable. When I select 'A' or 'B' or both, correct value is obtained. Separator to be put between field records. 1. SubStringCount seems to be doing what I want, but I still have a small problem. Somewhere, we. Hi, I am learning about the field function getfieldselections, here at the Qlik page: - 1880939I don't think we have function like that , you need to make use of multiple getfieldselection () function to achieve this but having the field name with the selection is more informative rite ?? because if 2 fields have similar values then without the field name , end user might get confused in which field he has made the selection. if val. For instance : I have a table chart with columns - salesperson, address, - 1839619. And also I'm using getfieldselection function, to select startmonth only for the selected endmonth. But the selections can happen only within the filters on the chart. Syntax: GetCurrentField (group_name)Return data type: string Arguments: group_name: The name of the group to be evaluated. Within our application, we have several fields which are used to control navigaton and other flow within the application. How do I get the syntax to allow multiple selections because currently it will only allow one selection. It is possible to query an alternate state. GetSelectedValues. Syntax: GetFieldSelections. If the identified field includes selections, then the selected (green) fields are counted. Qlik sense ignore filters / selections. The variable 'var' get the current selected values of field 1 and passes it to field 2 in the set analysis expression. =Conc. View solution in original post. Thanks. If they choose a country other than the current selection, then I call the Qlik Sense API to select the new country. I've set a table to alternate state and want to get in that table the selections from a mainstate table. We would like to show you a description here but the site won’t allow us. the easiest option would be to type in the search text in the filter pane and the hit "enter" to select all the entries which match the search term. include_excluded: If set to True(), the count will include selected values, which are currently excluded by selections in other fields. GetFieldSelections () returns a string with the current selections in a field. Hi Community. If you select all values and the count of all values is greater than max_values, the text ALLwill be returned. Hi. In the following, the field MyGroup includes the fields Sales and Price, and the following syntax:. functions. Text search is the main search method you can use in Qlik Sense. GetPossibleValues. To specify a new line set record_sep to chr (13)&chr (10). GetCurrentSelection(); foreach (var selectedField in currentSelection. I've added another list box so a second Forecast Type can be selected. chr (39) & GetFieldSelections (Field, chr (39) & ',' & chr (39), 12) & chr (39. I thought about using GetPossibleCount () instead, but I don't know how to determine if it 0 or all values are selected in master. Environments: Qlik Sense Enterprise / Qlik Analytics Platform All versions; Cause. Make selections Select some values in a field Select some values in a field by using the SelectValues method or the LowLevelSelect method. IF (LEFT (FIELD,4) = 'xxxx', FIELD,NULL ()) I then would like to use the GetfieldSelections () Function to identify what one has been selected. csv; The script example will generate a field DayOfWeek with the weekdays written in clear text. The list can be quite long, so I use the three parameter variant to set a very high maximum. Four fields contain selections. GetFieldSelections limitations. Conclusion . Hi All, Thanks in advance for any assistance. some thing like GetFieldSelections (<State1> Field1) is not possible in Qlikview 11. I am currently reloading the large dataset and will try your solution. For example if we want to know selection made in a field which has an alternative state and have. QlikView supports a number of different ways of presenting field values and making selections in list boxes, charts and other objects. I have 2 linecharts. (Before you wonder why I am doing this: It is used for a Special Business case where I need to compare two Fact Tables which cannot be linked due to insufficient Key Fields) app. i want to display the average value of the field (ex: avg(S14)) for a year( i mean for the selected year). It takes a field name. Use Adding actions to sheets . Managing data. To specify a new line, set record_sep to chr (13)&chr (10). GetCurrentSelections () returns the current selections in the document. GetField ("My Calendar field"). 5. This might seem strange but there is a reason I'm trying to do it this way. If the selections are instead made using a search string in a search box, GetCurrentSelections () returns the search string. Field functions. To specify a new line, set record_sep to chr (13)&chr (10). If a selection is made successfully, this block will return. Setting a default bookmark to create an app landing page - Qlik Sense. The user can select several KPI's with fieldname KPI_Description. And I get this correct with the expression above. Sharma, I'm assuming you have the triggers sorted for the removal of selections but for the 're-selection' of a previous value I'd suggest looking at Set Analysis - the often ignored use of Set Analysis: =sum ( {$1}Sales) will give you the Sales based on your previous selection, =sum ( {$2}Sales) will give. We just last week received training on QlikView. The table for "Sales" has one column "salesYear". If is 3, the third highest value is returned, and so on. The problem is when you need to check for alphanumeric values, say month "jan" and "feb" hardcoded woul look like. go to filed at left hand side asset panel ->search your field->right click->field setting->select Always one selected value option and save. When using a data island, applying the selection from a field in the data island to a field in the main model. talk is cheap, supply exceeds demand. some thing like GetFieldSelections (<State1> Field1) is not possible in Qlikview 11. The handle of the request is 2 because the handle of the list object is 2. I'm trying to get the selection of a filter with an auto calendar field: [DocDate. I am trying to use the GetFieldSelections with the "Select in Field" Action to Trigger a selection in another Dimension with exactly the same values. Using GetFieldSelections (KPI_Description) I get Margin. qlik sense.