topic Re: merge headers in pivot table in QlikView

merge headers in pivot table

Thu, 07 Aug 2014 12:16:47 GMT

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

Re: merge headers in pivot table

Thu, 07 Aug 2014 18:35:11 GMT

I have attached Sample data also.

Thanks

Re: Re: merge headers in pivot table

JonnyPoole — Thu, 07 Aug 2014 18:40:34 GMT

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'.

Re: merge headers in pivot table

Fri, 08 Aug 2014 07:51:00 GMT

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

Re: Re: merge headers in pivot table

Fri, 08 Aug 2014 11:12:18 GMT

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