Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

sushil353
Honored Contributor II

how to change column name dynamically??

Hi All,

I want to change a coulmn name in a straight table chart type in such a way that when ever i make a selection in a field the coulmn name sould change accordingly..   

for example..

In a chart i am calculating a coulmn as  sum(total_unit_processed) and there is field called operation in which various operation like X,Y,Z are there..

If i select X then sum(total_unit_processed) is calculated for X operation.

Now i want to name this coulmn like when X is selected then heading of coulmn should be total unit processed for X  and if i select then the heading should be total unit processed for Y.....

please help me out....

Thanks

1 Solution

Accepted Solutions
lironbaram
Honored Contributor II

how to change column name dynamically??

hei

you can try something in the lines of

='total unit Processed for ' & concat(OpeartionField,',')

that way it will show you all the fields availble in the operation field

6 Replies
sushil353
Honored Contributor II

how to change column name dynamically??

Hi All,

Coulmn name of heading means The lable of that perticular expression

lironbaram
Honored Contributor II

how to change column name dynamically??

hei

you can try something in the lines of

='total unit Processed for ' & concat(OpeartionField,',')

that way it will show you all the fields availble in the operation field

how to change column name dynamically??

Hi Sushil,

You also able to fetch by this code ='total unit Processed for ' & concat(getcurrentselections(OperatedField,',')

By this you get field value, hope this helps you.

Regards,

Anand

Not applicable

how to change column name dynamically??

Hi Sushil,

you can try this

='total unit processed for' & getfieldselections(operation,';')


Not applicable

Re: how to change column name dynamically??

Hi Sushil,

Try the following:

First, go to Settings, then 'Variable Overview' to create a variable such as :

vOperation  =Operation .

U can now go back to your straight table chart where u calculate your sum(total_unit_processed): On the label

type in this expression: =if(Operation='$(vOperation)',Operation,'total_unit_processed'). I have a test:

Regards.

sushil353
Honored Contributor II

how to change column name dynamically??

Thanks biteguebiessono .... Great example

Community Browser