what is And-mode

[#1]

Hello All,

     I am new to qlikview .

can someone tell me about And-Mode of listboxes.

Thanks.

[narender123]

Hi,

It is just like.if you want sum of product with a condition where A and B are equal.

Look at this link.This will help you.

http://community.qlik.com/message/127398#127398

Thanks.

Narender

[er_mohit]

hii

Here in qlikview on multiple selection it works like OR Gate means It shows the values regarding your multiple selection all the data didnt show the data which is in between your selection so, for this purpose we use or gate

i share with you our example regards AND mode

see the attached file

[Anonymous]

A detailed briefing was posted on this to this forum minutes before your posting:

http://community.qlik.com/thread/62060?tstart=0

Jonathan

[#5]

Thank u

All of u for such good response.

[narender123]

If you got your answer then mark correct answer and close the question sothat creect answer would help someone else..

Thanks

[#7]

Hello Mohit,

          I got working of  and-mode . but for some fields and-mode option is enable and for some are not why ?

can u pls explain.

Thank U.

[er_mohit]

hii because to enable AND mode there are couples of rules that we need to follow:-

1)Field in list box must be contained in table that has only two fields

2)the other field in table is associatiom(or ID) field.This field is only contained in this table

the table must have been load distinct key word

o, because pid field have a key which gives to understand what quantity lies in between two value

like in above example select from pid is A102 and A103

u see the related Quantity as per selection but in and mode field it when you select both it tells between this selection which quantity lies

hope it helps you

Regards

Mohit