Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
rohit214
Contributor III

how to activate and mode in list box

hi all

i am using qv9.0 .i am not able to activate and mode in list box.

please help me

thanks & regard

rohit

1 Reply
dennisnet
Valued Contributor III

how to activate and mode in list box

Hi Rohit,

From the help file:

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 *.

Hope it's helpfull,

Dennis.

Community Browser