topic Re: Chain on selected fields in QlikView

Chain on selected fields

kristof_j — Mon, 22 Aug 2016 10:13:11 GMT

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:

copy the current selections in a 2nd state
lock the field(s) I want to chain in 2nd state
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?

Re: Chain on selected fields

adamdavi3s — Mon, 22 Aug 2016 10:18:10 GMT

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

Re: Chain on selected fields

migueldelval — Mon, 22 Aug 2016 10:23:34 GMT

Hi Kristof,

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

Regards

Miguel del Valle

Re: Chain on selected fields

kristof_j — Mon, 22 Aug 2016 11:09:20 GMT

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.

Re: Chain on selected fields

adamdavi3s — Mon, 22 Aug 2016 11:11:20 GMT

Hi Kristof,

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

Re: Chain on selected fields

adamdavi3s — Mon, 22 Aug 2016 11:20:09 GMT

Please see attached

Re: Chain on selected fields

kristof_j — Mon, 22 Aug 2016 11:30:10 GMT

That's easy and helpful

I'll try to build further on your example