Variable reference object

Wed, 27 Mar 2013 18:34:46 GMT

Hi Community,

I've got the following issue.

I have got a table with one dimension (names) and several expressions (calculation based on uploaded data).

Now I want to use one of the items in the dimension list (flexible) as a reference which results in a calculation of differences in relation to this selected reference.

Example to explain it better:

Start table

Name	Value	Delta to reference
A	1	-
B	2	-
C	3	-
D	4	-

To select a reference name, a drop down box (containing A-B-C-D) should be shown.

When I select C in this box, this would result in the following table

Name	Value	Delta to reference
A	1	-2
B	2	-1
C	3	0
D	4	1

How can I create this drop down box. This list is flexible and depending on the selection in the Dimension of the table.

Thanks in advance for you quick respons.

Kind regards

Re: Variable reference object

Wed, 27 Mar 2013 18:46:18 GMT

Here is one way.

topic Variable reference object in QlikView

Variable reference object

Re: Variable reference object