topic Re: Change labels dynamically in straight table in QlikView

Change labels dynamically in straight table

Pedro_Rodriguez — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have a bit of a challenge, I want to build a straight table whose field labels in the expressions can be changed dynamically.

The data table is called 'Data':

Field1OLD	LabelOLD1	LabelOLD2	LabelOLD3
aa	1	43	632
bb	2	5	3
cc	3	3	2

I also have other table called 'Labels', containg the old field's names, the new ones, plus the tooltips for the Comments in the espressions and the field No that i'll use to show/hide columns:

FieldNameOld	FieldNameNew	No	Tooltip
LabelOLD1	LabelNEW1	1	Label 1
LabelOLD2	LabelNEW2	2	Label 2
LabelOLD3	LabelNEW3	3	Label 3
LabelOLD4	LabelNEW4	4	Label 4

So, in the atached you can see both tables, and the table 'MAIN TABLE Goal' which is what i want to achieve but dynamically.

To do thath I suspect the tables Data and Labels should be joined or crossed or something.

Please could anyone help

Thx!

Re: Change labels dynamically in straight table

arvind_patil — Fri, 20 Jul 2018 11:27:54 GMT

Hi Pedro,

Please convert first table in cross table and then simply concatenate it.

Table1:

Crosstable (FieldNameOld, Vaqlue, 1)

LOAD.

From Table1;

Concatenate(Table1)

LOAD.

From Table2;

Now you can create dynamic output as required you

Thanks,

Arvind Patil

Re: Change labels dynamically in straight table

sunny_talwar — Fri, 20 Jul 2018 11:33:47 GMT

Not sure what you mean when you say dynamically, but is this what you need?

=Only({<FieldNameOld = {'LabelOLD1'}>} FieldNameNew)