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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
kristof_j
Creator III
Creator III

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
Master
Master

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

migueldelval
Specialist
Specialist

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
Creator III
Creator III
Author

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
Master
Master

Hi Kristof,

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

adamdavi3s
Master
Master

Please see attached

kristof_j
Creator III
Creator III
Author

That's easy and helpful

I'll try to build further on your example