List Box Selection

jagannalla — Mon, 02 May 2011 16:45:19 GMT

Hi,

- I want to select "And mode" in the list box.

- I selected one field in the list box but "And mode" option is disabled, how can i enable the "And mode" option for list box.

List Box Selection

erichshiino — Mon, 02 May 2011 16:51:41 GMT

From QV reference, there is a lot of restrictions to use it:

And-Tables

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 logical 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, you must use a preceding Load distinct *.

This is from QV 10 SR2 Help file

Hope it helps,

List Box Selection

jagannalla — Mon, 02 May 2011 17:12:30 GMT

OK thank q very much to response.......

topic List Box Selection in QlikView

List Box Selection

List Box Selection

And-Tables

List Box Selection