topic Copy selection in QlikView

Copy selection

kris_vliegen — Fri, 26 Jun 2015 11:11:59 GMT

Hi all,

I have a dashboard with prices from shops from different ( concurrent) shopbrands.

So they can see if the price for a specific product is good.

Now I have different users who all have there own brand.

I have implemented section access to connect the user to an brand.

Is it possible that the the brand of section-access should always be selected in de brandlist and that the user can choose with what brand they wel compare?

Brand from section access = abc

Brandlist

abc

def

fgh

dkl

abc should always be selected and the user should select al the other or one or 2 or .. of the other brands.

Regards,

Kris

Re: Copy selection

Fri, 26 Jun 2015 12:24:04 GMT

Hi Kris,

if you are using abc as your section access, that will be the only value in the brandlist surely? You want when abc is used in section access to just select that value but not reduce the overall data?

You have the option with section access to make a reduction as an initial selection, rather than drop out data, is that what you are looking for maybe?

Hope that helps

Joe

Re: Copy selection

kris_vliegen — Fri, 26 Jun 2015 13:25:49 GMT

Hi Joe,

This isn't working for me.

If I set the initial Data Reductien Based on Section Access I get this for "Merk"

And if I do it with your settings I get this

So He doen't do any selection.

Is there a way to select the brand from the txt-file( section access)

And that the user can't deselect this value?

But that he can select other brands to make a comparison.

Re: Copy selection

giakoum — Fri, 26 Jun 2015 13:28:38 GMT

if I understood well, there will be only one value per user after section access reduction?

You can set it as "Always one selected value"

Re: Copy selection

kris_vliegen — Fri, 26 Jun 2015 13:32:05 GMT

"Always one selected Value" is not my solution.

de user should select all the values or select just 2 or ... But his brand should always stayed selected.

Re: Copy selection

giakoum — Fri, 26 Jun 2015 13:35:18 GMT

aha ok.

Then you need a trigger on the field that will select whatever the user has selected plus his own brand

settings --> document properties --> triggers

Re: Copy selection

kris_vliegen — Fri, 26 Jun 2015 13:36:34 GMT

And how do I define this trigger.

Select in field and then?

Re: Copy selection

giakoum — Fri, 26 Jun 2015 13:56:45 GMT

see attached example

whatever you select in customer, customer A is always selected

Re: Copy selection

kris_vliegen — Fri, 26 Jun 2015 14:15:44 GMT

Thanks this is working but only if there is no space in te mark.

so if the own mark is 'abc' and the user will select the mark 'bcd' this is working

But if he will select 'def geh' it isn't working.

Re: Copy selection

giakoum — Fri, 26 Jun 2015 14:20:46 GMT

not in my example

if you select B and D by holding down Cntrl, A is also selected

Re: Copy selection

kris_vliegen — Fri, 26 Jun 2015 14:34:12 GMT

Yes, but what with this

The B E isn't selecting

Re: Copy selection

giakoum — Fri, 26 Jun 2015 15:15:13 GMT

the you need to use double quotes for the values. replace the trigger expression with :

='("' & GetFieldSelections(Customer, '"|"') & '"|"A")'

Re: Copy selection

kris_vliegen — Wed, 01 Jul 2015 06:35:34 GMT

Thanks all for your responses.

Regards,

Kris