Dynamic field change in Straight table - Qliksense

Below is the process to change the dimension dynamically in table in which all measures remains same.

Build a inline table with one field and give the field names as values for that field

Example inline table looks as below

Load * Inline
[
Dimension
Dimension1,
Dimension2,
Dimension3,
];


Use below expression in the dimension field for straight table

=IF(GetSelectedCount(Dimension)=1,
IF(Dimension='Dimension1',Dimension1,
IF(Dimension='Dimension2',Dimension2,
IF(Dimension='Dimension3',Dimension3,
))),Dimension1)

Use below expression in the straight table label to reflect label name dynamically whenever make a selection in the filter

=IF(GetSelectedCount(Dimension)=1,
IF(Dimension='Dimension1','Dimension1',
IF(Dimension='Dimension2','Dimension2',
IF(Dimension='Dimension3','Dimension3',
))),'Dimension1')

and also use the same above expression in the filter title to get title updated dynamically updated when selection is changed. Default section is 'Dimension1' in all the expressions



Below screen shot explains a filter where the dimension needs to be selected and will change automatically in the straight table