Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

razvan_brais
Contributor II

Select field when variable has some value

Hy guys.
I have a question. I have a Variable custom object whith 2 predifined values 1, 2 . What I want to do is to selecte some certain values from a Field when variable is , let`s say 1.

So if I select 1 then I need to automaticaly select some values from Other field.

Is this possible?

Thank you,

Razvan

1 Solution

Accepted Solutions
razvan_brais
Contributor II

Re: Select field when variable has some value

Solved with Sheet Navigation .

Thank you for support.

11 Replies

Re: Select field when variable has some value

This is possible, Can you share sample mockup test file

razvan_brais
Contributor II

Re: Select field when variable has some value

I`ll try to add some data. But I would like to specify that the app is in qlik sense , not in qlik view , so I can`t use triggers.

razvan_brais
Contributor II

Re: Select field when variable has some value

So this is the example.

I this example I would like if I select V1 then to automatically select from Field1 values : 'A' , 'B'.

agigliotti
Honored Contributor II

Re: Select field when variable has some value

you can do it using this extension http://branch.qlik.com/#!/project/58e20b0e86f54ab8e8f21512

you  have to set  "Select Multiple Values in Field" as first action

and type in Value something as below:

=if( $(vMakeSelections) = 1, 'A;B' )

I hope it helps.

razvan_brais
Contributor II

Re: Select field when variable has some value

I`ve tried , but nothing happens . Maybe I`m doing something wrong :-?

razvan_brais
Contributor II

Re: Select field when variable has some value

What I observed , it only works on change sheet. But I need the action to be made in current sheet

anatbabv
Contributor

Re: Select field when variable has some value

may be you have to use Extension objects.Qlik Branch

razvan_brais
Contributor II

Re: Select field when variable has some value

Won`t help me

agigliotti
Honored Contributor II

Re: Select field when variable has some value

yes you right, the event is fired when you open the sheet.