Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Merging Headers name in Pivot Table with variable date

Hi,

Appreciate if anyone can help me on this issue. I have a pivot table to that i need to merge column headers with variable dates. For instance, kindly refer to the image below.

merging pivot table.PNG

As your info, the user able to select range of dates and it reflects to the column header i.e. 'Cumulative as at 31/12/2017' and 'Current Week (31/12/2017-7/01/2018)'. Is it possible to do merging columns with variables? I hope that you guys able to help me on this issue.

Thanks.

Regards

Vincent

2 Replies
Anil_Babu_Samineni

Not sure, I follwed you. Can you share application to test?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

As per request, kindly find the attachment here. Thanks