topic Re: how to change column name dynamically?? in QlikView

how to change column name dynamically??

sushil353 — Tue, 16 Aug 2011 10:17:19 GMT

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

how to change column name dynamically??

sushil353 — Tue, 16 Aug 2011 10:24:19 GMT

Hi All,

Coulmn name of heading means The lable of that perticular expression

how to change column name dynamically??

lironbaram — Tue, 16 Aug 2011 10:28:08 GMT

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??

its_anandrjs — Tue, 16 Aug 2011 10:39:18 GMT

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

how to change column name dynamically??

Tue, 16 Aug 2011 11:09:04 GMT

Hi Sushil,

you can try this

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

Re: how to change column name dynamically??

Tue, 16 Aug 2011 11:30:39 GMT

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.

how to change column name dynamically??

sushil353 — Tue, 16 Aug 2011 11:46:25 GMT

Thanks biteguebiessono .... Great example