Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When pulling across an entire table , the variables in the column headers work correctly. eg. last or prior year becomes 2017 as below.
However, when brining in the individual columns the column label or header stays as PY prior year and the variable is not working to give 2017.
Does the column header have to manually edited?
Hi,
Yes, you have to remove the column header dropped from the table, create a formula that calculate it and drag and drop that formula as new column header.
Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.