merge headers in pivot table

[#1]

Hi QV,

Pls. refer to the qlikview file and expected output image file for reference.

My requirement is I would like to add a "TrendLine"  to the columns regarding week intervals.Normaly I would like to add an extra dimention and then drog it top using the pivot option but I am unable to succeed .

How can I achiecve merged header ,looking much forward for your replies.

Thanks

Message was edited by: SwathiRaj P

[#2]

I have attached Sample data also.

Thanks

[JonnyPoole]

Not sure if this is what you are looking for. in your example i had to grab the expressions and pull them 'down' rather than pull the trend field 'up'. 

[#4]

Hello,

I tried a workaround for this. Hope that meets your expectations. But I still believe this needs a more better approach.

PFA.

Thanks,

Angad

[#5]

Thank you Angad for your effort but label should not be static one ,it should be dynamic based on SNO_WEEK field.

If SNO_WEEK =1 label should ne FW17,

IF SNO_WEEK>= 1 and SNO_WEEK<=4 label should be FW13-FW17

SNO_WEEK	FISCAL_YEAR_WEEK
1	201417
2	201416
3	201415
4	201413

I hope you understand.

Thanks