Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

help me out in change of column name in pivot table

Hi

4 Replies
Anonymous
Not applicable
Author

Hi,

I am not sure if I understand your question correctly. Basically you want to change column name "Actual %" to "Previously Calc"?

I believe you have field which has "Actual", "Budget" and "Actual %" label. You may user Replace function to change the column name in pivot table. See below,

Replace(FieldName, 'Actual %', 'Previously Calc')

Not applicable
Author

Satyadev

Thanks for your response

I need the solution like previously it was "Calc" now i need to change to "Actual%" in Pivot table

Actuals and Budget and Actual% i need this solution

Anonymous
Not applicable
Author

Hi,

You can change a dimension's label in the following field, although 'Label' checkbox seems to be unable you can type the new name in that box:test.PNG.png

Also, expression's label here can be modified in the following field:

test.PNG.png

I hope this could help you.

Regards,

Not applicable
Author

Thanks for your response

but this approach is not fit for the requirement