Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
kris_vliegen
Partner - Creator III
Partner - Creator III

Copy selection

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

1 Solution

Accepted Solutions
giakoum
Partner - Master II
Partner - Master II

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

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

View solution in original post

12 Replies
Not applicable

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?

selection.PNG

Hope that helps

Joe

kris_vliegen
Partner - Creator III
Partner - Creator III
Author

Hi Joe,

This isn't working for me.

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

Section.JPG

And if I do it with your settings I get this

Section1a.JPG

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.

giakoum
Partner - Master II
Partner - Master II

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"

kris_vliegen
Partner - Creator III
Partner - Creator III
Author

"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.

giakoum
Partner - Master II
Partner - Master II

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

kris_vliegen
Partner - Creator III
Partner - Creator III
Author

And how do I define this trigger.

Select in field and then?

giakoum
Partner - Master II
Partner - Master II

see attached example

whatever you select in customer, customer A is always selected

kris_vliegen
Partner - Creator III
Partner - Creator III
Author

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.

giakoum
Partner - Master II
Partner - Master II

not in my example

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

Capture.PNG