topic Re: Andmode Selection in QlikView

Andmode Selection

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

How can i select two selection in list box by using "Andmode" as given below? with out holding keyboard?

Re: Andmode Selection

Tue, 12 Jul 2016 06:10:41 GMT

Hi,

You can drag a mouse cursor on the fields that you want to select.

Re: Andmode Selection

qlikview979 — Tue, 12 Jul 2016 06:18:00 GMT

Hi I Tried that ,but getting . when i am leaving "Ctrl" selection is gone.

Re: Andmode Selection

arulsettu — Tue, 12 Jul 2016 06:19:38 GMT

no need of keyboard support. just click the value from list box and drag up to second value

Re: Andmode Selection

qlikview979 — Tue, 12 Jul 2016 06:20:00 GMT

Hi Vrushali,

please find the attached file. I want like that

Re: Andmode Selection

qlikview979 — Tue, 12 Jul 2016 06:23:46 GMT

Hi arul,

I done like that also.

when i leaving the mouse selection is gone . if i hold mouse coming like this.

Re: Andmode Selection

varshavig12 — Tue, 12 Jul 2016 06:27:59 GMT

And Mode

https://community.qlik.com/blogs/qlikviewdesignblog/2013/07/19/and-mode

Re: Andmode Selection

arulsettu — Tue, 12 Jul 2016 06:29:23 GMT

can you post sample to try that

Re: Andmode Selection

varshavig12 — Tue, 12 Jul 2016 06:41:55 GMT

If you hold the mouse for a little long,

instead of and-mode it will exclude them i.e "not" instead of "and".

Re: Andmode Selection

qlikview979 — Tue, 12 Jul 2016 06:42:20 GMT

Hi Varsha,

I Seen that, but i am not able to select Two selection in list box.

Regards,

Mahesh

Re: Andmode Selection

varshavig12 — Tue, 12 Jul 2016 06:51:18 GMT

I just found this:

Change the style of your list box.

How to select multiple values one-by-one without CTRL-key?

Re: Andmode Selection

qlikview979 — Tue, 12 Jul 2016 06:51:44 GMT

Hi arul,

Please find my attachment files

Re: Andmode Selection

Tue, 12 Jul 2016 06:53:59 GMT

Hi Mahesh,

Please go to Document properties - Sheet option- Select a list box- go to its properties and check whether and mode is checked.

If an option for and mode is disabled, you need to create and mode table.

for reference: And-Mode: How to enable AND and NOT selections with Green, White, Grey...and Red!

Re: Andmode Selection

varshavig12 — Tue, 12 Jul 2016 06:54:52 GMT

In the presentation tab ----> change the "Selection Style Override" to "LED Check boxes".

Re: Andmode Selection

qlikview979 — Tue, 12 Jul 2016 07:00:11 GMT

Hi Varsha,

I done that , one box is showing green color,second one is showing red color.I think that is not a correct way.

Regards

Re: Andmode Selection

qlikview979 — Tue, 12 Jul 2016 07:02:37 GMT

Hi, I check that these is no "And mode" option. how can i create mode table.

Regards

Re: Andmode Selection

arulsettu — Tue, 12 Jul 2016 07:07:58 GMT

like this?

Re: Andmode Selection

qlikview979 — Tue, 12 Jul 2016 07:14:24 GMT

Yes

Re: Andmode Selection

arulsettu — Tue, 12 Jul 2016 07:15:37 GMT

try this

T1:

LOAD Employee,

Manager,

LOB,

Amount

FROM

(ooxml, embedded labels, table is Sheet1);

T2:

load Distinct

LOB ,

Employee as employees

Resident T1;

enable and mode in properties

Re: Andmode Selection

qlikview979 — Tue, 12 Jul 2016 07:17:19 GMT

Hi,

When i am taking Employee field it's working. if i take LOB field its nor working Why any issue is there.

Regards