<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic How to select multiple values one-by-one without CTRL-key? in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/How-to-select-multiple-values-one-by-one-without-CTRL-key/m-p/392953#M146574</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;By default, you can only select multiple items in a listbox using the CTRL-key. (or dragging your mouse pointer)&lt;/P&gt;&lt;P&gt;However, when you forget to hold the CTRL-key once, the selection you already made is gone. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;We want to create a UI where the user does not have to hold the CTRL-key to select multiple items in a listbox. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Is there a way to create a UI where every select of the user is ADDED to the selection,&lt;/P&gt;&lt;P&gt;instead of a REPLACEMENT of the selection? Ofcourse, the downside is the user needs&lt;/P&gt;&lt;P&gt;to click every item again to REMOVE it from the selection, but this will be fine for our case.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;We were thinking about 2 listboxes: Listbox A displaying all currently available (unselected) items.&lt;/P&gt;&lt;P&gt;Listbox displays only the already selected items. This is a very common UI element in Windows applications,&lt;/P&gt;&lt;P&gt;where the user picks a left hand item, presses the "&amp;gt;" or "Add" button and the item is "moved" &lt;/P&gt;&lt;P&gt;to the right hand listbox. For instance, the Sheet Properties contains just such an element&lt;/P&gt;&lt;P&gt;for selecting which object are linked to the sheet... We want to emulate this behaviour within a QlikView model.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;For the left hand listbox A, displaying only the available items, we used an expression:&lt;/P&gt;&lt;P&gt;=If( GetSelectedCount( Field ) &amp;gt; 0, Aggr( Only( {1-$} Field ), Field ), Field )&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;For the right hand listbox B, we display only the selected items:&lt;/P&gt;&lt;P&gt;=Aggr( Only( {$} Field ), Field ) &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;So the display is right, but ofcourse QlikView's selecting behaviour is not altered. When we select&lt;/P&gt;&lt;P&gt;an additional item in listbox A, the previous selection is reset and overwritten with the new selection.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Is there a way, perhaps with some triggers, or a local variable storing the selected list, or ... ???&lt;/P&gt;&lt;P&gt;to emulate this behaviour within QlikView?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Fri, 30 Nov 2012 00:43:08 GMT</pubDate>
    <dc:creator />
    <dc:date>2012-11-30T00:43:08Z</dc:date>
    <item>
      <title>How to select multiple values one-by-one without CTRL-key?</title>
      <link>https://community.qlik.com/t5/QlikView/How-to-select-multiple-values-one-by-one-without-CTRL-key/m-p/392953#M146574</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;By default, you can only select multiple items in a listbox using the CTRL-key. (or dragging your mouse pointer)&lt;/P&gt;&lt;P&gt;However, when you forget to hold the CTRL-key once, the selection you already made is gone. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;We want to create a UI where the user does not have to hold the CTRL-key to select multiple items in a listbox. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Is there a way to create a UI where every select of the user is ADDED to the selection,&lt;/P&gt;&lt;P&gt;instead of a REPLACEMENT of the selection? Ofcourse, the downside is the user needs&lt;/P&gt;&lt;P&gt;to click every item again to REMOVE it from the selection, but this will be fine for our case.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;We were thinking about 2 listboxes: Listbox A displaying all currently available (unselected) items.&lt;/P&gt;&lt;P&gt;Listbox displays only the already selected items. This is a very common UI element in Windows applications,&lt;/P&gt;&lt;P&gt;where the user picks a left hand item, presses the "&amp;gt;" or "Add" button and the item is "moved" &lt;/P&gt;&lt;P&gt;to the right hand listbox. For instance, the Sheet Properties contains just such an element&lt;/P&gt;&lt;P&gt;for selecting which object are linked to the sheet... We want to emulate this behaviour within a QlikView model.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;For the left hand listbox A, displaying only the available items, we used an expression:&lt;/P&gt;&lt;P&gt;=If( GetSelectedCount( Field ) &amp;gt; 0, Aggr( Only( {1-$} Field ), Field ), Field )&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;For the right hand listbox B, we display only the selected items:&lt;/P&gt;&lt;P&gt;=Aggr( Only( {$} Field ), Field ) &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;So the display is right, but ofcourse QlikView's selecting behaviour is not altered. When we select&lt;/P&gt;&lt;P&gt;an additional item in listbox A, the previous selection is reset and overwritten with the new selection.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Is there a way, perhaps with some triggers, or a local variable storing the selected list, or ... ???&lt;/P&gt;&lt;P&gt;to emulate this behaviour within QlikView?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 30 Nov 2012 00:43:08 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-to-select-multiple-values-one-by-one-without-CTRL-key/m-p/392953#M146574</guid>
      <dc:creator />
      <dc:date>2012-11-30T00:43:08Z</dc:date>
    </item>
    <item>
      <title>Re: How to select multiple values one-by-one without CTRL-key?</title>
      <link>https://community.qlik.com/t5/QlikView/How-to-select-multiple-values-one-by-one-without-CTRL-key/m-p/392954#M146575</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi You can just chage the style of the list box . Which will look some thing like below. There will be no need for the User to select the Ctrl Key. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Alvin.&lt;/P&gt;&lt;P&gt;&lt;IMG __jive_id="25840" class="jive-image" alt="Selection.bmp" src="https://community.qlik.com/legacyfs/online/25840_Selection.bmp" /&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 30 Nov 2012 02:36:04 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-to-select-multiple-values-one-by-one-without-CTRL-key/m-p/392954#M146575</guid>
      <dc:creator>alvinford</dc:creator>
      <dc:date>2012-11-30T02:36:04Z</dc:date>
    </item>
  </channel>
</rss>

