topic Re: what is And-mode in QlikView

what is And-mode

Tue, 04 Jun 2013 07:28:54 GMT

Hello All,

I am new to qlikview .

can someone tell me about And-Mode of listboxes.

Thanks.

Re: what is And-mode

narender123 — Tue, 04 Jun 2013 07:39:21 GMT

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

Re: what is And-mode

er_mohit — Tue, 04 Jun 2013 07:45:29 GMT

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

Re: what is And-mode

Anonymous — Tue, 04 Jun 2013 07:46:13 GMT

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

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

Jonathan

Re: what is And-mode

Tue, 04 Jun 2013 08:37:52 GMT

Thank u

All of u for such good response.

Re: what is And-mode

narender123 — Tue, 04 Jun 2013 09:26:26 GMT

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

Thanks

Re: what is And-mode

Wed, 05 Jun 2013 06:06:52 GMT

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.

Re: what is And-mode

er_mohit — Wed, 05 Jun 2013 06:42:06 GMT

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