Discussion Board for collaboration on QlikView Layout & Visualizations.
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..
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....
Go to Solution.
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
Coulmn name of heading means The lable of that perticular expression
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.
you can try this
='total unit processed for' & getfieldselections(operation,';')
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:
Thanks biteguebiessono .... Great example