Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
kristof_j
Contributor II

Chain on selected fields

Hi

I want to chain between several documents with several common dimensions. When I chain, I don't want to chain on all the dimensions but only on a selection of dimensions.

Today when I do a doc chain I do the following:

  1. copy the current selections in a 2nd state
  2. lock the field(s) I want to chain in 2nd state
  3. clear fields of 2nd state

Step 2 bothers me. It is hard coded which fields must be locked. Every time I want to chain the selection of my dimensions I need to chain, I have to change the actions.

Is there a way to dynamically lock a selection of fields? With a macro?

6 Replies
adamdavi3s
Honored Contributor

Re: Chain on selected fields

How are you determining the fields which need to be locked? This should be possible with variables somehow!

migueldelval
Valued Contributor

Re: Chain on selected fields

Hi Kristof,

I can´t understand you so well, but you can try to use getfieldselection, to make it.

Regards

Miguel del Valle

kristof_j
Contributor II

Re: Chain on selected fields

Today I make several button

- one for Dim1

- one for Dim2

- one for Dim1 and Dim2

- ...

With our apps we need to chain on several dimensions but not all of them.

So I want to create something so that we can decide with a selection box, variable, macro ... which fields we want to chain in stead of creating a button for every combination.

adamdavi3s
Honored Contributor

Re: Chain on selected fields

Hi Kristof,

That makes sense... let me knock up an example for you quickly!

adamdavi3s
Honored Contributor

Re: Chain on selected fields

Please see attached

kristof_j
Contributor II

Re: Chain on selected fields

That's easy and helpful

I'll try to build further on your example