Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
gjamila_esq
Contributor

How to pass the value of a field to another field?

Hello, my goal is to navigate selections by making sure that, if I select certain values from field​​1, they are reflected in the field2, erasing the selection from the field 1.

Let me explain with an example:

This is my table


Dim1 Dim2 Dim3
AaX
AaY
AaZ
AbX
AbY
AbZ
BcX
BcY
BcZ
BdX
BdY
BdZ
CeX
CeY
CeZ
CfX
CfY
CfZ


Now, I select value B from Dim1


Dim1 Dim2 Dim3
BcX
BcY
BcZ
BdX
BdY
BdZ


Now I want that Dim2 is filtered by the value I selected in Dim1, in this way:


Dim1 Dim2 Dim3
AbX
AbY
AbZ


Up to here it works using a button and a variable.

I created a variable: variabile1=GetFieldSelections( Dim1).

The button has three actions:

Select in field --> Dim2=variabile1

Clear field --> Dim1

Clear field --> Dim2

You can see my example attached.


1. Is there a way to do this without a button?

2. If I select multiple value from Dim1, my button doesn't work. Any idea?


Thanks!