1 Reply Latest reply: Nov 1, 2012 9:16 AM by Mayil Vahanan Ramasamy RSS

    Listbox properties


           Can someone temme the use of 'AND mode option in listbox properties ??

           And i unable to select that option in my list box , ???


           Thanks in advance..




        • Re: Listbox properties
          Mayil Vahanan Ramasamy



          From Help:


          A field cannot always be set to logical And mode. The reason for this is that the and alternative is logically meaningful only if the concerned field is linked to only one other field.

          The And mode option is only allowed under very strict conditions, imposed by the theory behind the QlikView logic. In order to be used in And mode, the following criteria must be fulfilled:

          • the field must only exist in one internal table,
          • the field must be the second column of no more than two columns, and
          • the table must not contain any duplicate records, and 
          • the table must be loaded using a distinct qualifier. If the table is loaded using a Select statement, a preceding Load distinct * must be used.


          Please find attached file