topic Re: Multi selection on Access Point in QlikView

Multi selection on Access Point

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

Hi all,

One of my user asked me for make a multi selection on dimension in a pivot chart. Non problem for select one value but unable to select more.

Regards

Re: Multi selection on Access Point

awhitfield — Tue, 10 Jan 2017 15:02:56 GMT

AFAIK you can't do this on a pivot chart, you may need to add a list box too.

Andy

Re: Multi selection on Access Point

awhitfield — Tue, 10 Jan 2017 15:08:19 GMT

On second look, enable Dropdown Selection on the presentation tab for you first dim, then you can multi select form the drop down:

Andy

Re: Multi selection on Access Point

marcus_sommer — Tue, 10 Jan 2017 15:09:49 GMT

Within the tab presentation you could enable a dropdown by each dimension - and then your user could click on this dropdown-arrow and choose their wanted values and even use operators or expressions, for example by a date-field:

>=01.01.2017

- Marcus

Re: Multi selection on Access Point

kuczynska — Tue, 10 Jan 2017 15:12:24 GMT

Hi,

What if you would set this column as "Dropdown Select"? Go to chart properties, Presentation tab, select your dimension and check "Dropdown Select" checkbox.

Then your user should be able to use this dimension with a functionality of listbox etc.

Not sure if that's what you were asking for, but hope this helps.

Good luck!

Re: Multi selection on Access Point

sergio0592 — Tue, 10 Jan 2017 15:23:06 GMT

Thanks to all for your answers. In fact i had already thought to Dropdown Select. But it's not so easy because dimension value are linked to a slider.

So when i use Dropdown, it display all value of my dim, not only those associated with the slider selection.

Re: Multi selection on Access Point

marcus_sommer — Tue, 10 Jan 2017 15:27:30 GMT

Maybe you could use a calculated dimension, like: aggr(only(YourField), YourField) which would react on the current selections.

- Marcus