topic Re: Adding an extra heading in pivot table in QlikView

Adding an extra heading in pivot table

mansi_dv — Mon, 10 Mar 2014 04:36:22 GMT

I have made a pivot table as given below by extracting data from an excel sheet.

_________________________________________________________________________________________________

Code || April | May | June | July | August | September | October | November | December | January | February | March |

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Now I want to add an extra header row above as :-

_________________________________________________________________________________________________

| Q1 | Q2 | Q3 | Q4 |

_____|________________ |______________________|____________________________|_____________________|__

Code || April | May | June | July | August | September | October | November | December | January | February | March |

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Can someone please help me out with this??

Re: Adding an extra heading in pivot table

tresB — Mon, 10 Mar 2014 04:49:47 GMT

Create an additional field, say 'quarter' in the script; use that as second dimension in pivot table; you can now drag it to column. Hope this helps.

Re: Adding an extra heading in pivot table

SunilChauhan — Mon, 10 Mar 2014 04:52:54 GMT

teke quarter column in dimension and drag it to anti clock wise in UI. above

This column

Code||aril| may........................

see the draged field in my attached example ( i mean To field draged from horizontal to Vertical)

hope this helps

Re: Adding an extra heading in pivot table

mansi_dv — Mon, 10 Mar 2014 05:41:23 GMT

By adding a column called quarter in the script and adding it as the second dimension and then dragging it anticlockwise, i get

_Q1_________________________________________________________________________________________|___Q2__________________________________________________________________________________| ___Q3_____________________________________________________________

Code || April | May | June | July | August | September | October | November | December | January | February | March | April | May | June | July | August | September | October | November | December | January | February | March |April | May | June | July | August | September | October | November | December | January | February | March |

All the months come under Q1, then again all the months come under Q2 and so on....

Re: Adding an extra heading in pivot table

tresB — Mon, 10 Mar 2014 05:44:01 GMT

Something is wrong in your script. Create a sample qvw and share so that we can have a look and help.

Re: Adding an extra heading in pivot table

mansi_dv — Mon, 10 Mar 2014 06:10:23 GMT

Here is a sample which I created.

Re: Re: Adding an extra heading in pivot table

tresB — Mon, 10 Mar 2014 06:19:50 GMT

PFA for sample.

Re: Adding an extra heading in pivot table

mansi_dv — Mon, 10 Mar 2014 06:23:57 GMT

Thank you for the reply.

But what if I have loaded the data from an excel file and then I want to add a new column for quarter?

Re: Re: Adding an extra heading in pivot table

tresB — Mon, 10 Mar 2014 06:31:29 GMT

You have to calculate quarter from your date field. The calculation expression would vary based on your date field. Example:

Load

'Q' & Ceil(Month/3) as Quarter // when Month is numeric

Re: Adding an extra heading in pivot table

Mon, 10 Mar 2014 06:47:18 GMT

What if I want to add a column with entirely new data using script and add it as a new header as explained above for quarters??

Re: Re: Adding an extra heading in pivot table

tresB — Mon, 10 Mar 2014 06:54:29 GMT

Divya,

The answer is same as I stated just above. If you have doubt, please cheate a sample qvw with your sample data inline and post it creating a new thread.

Re: Adding an extra heading in pivot table

SunilChauhan — Mon, 10 Mar 2014 07:18:13 GMT

Hi,

here Month and quarter are irrelated.

if Quarter is realted to Month then only you can plot quarter and month mapping properly.

if you calculate Month and Quarter from Date field then definelty its provide you accurate mapping b/w quarter and months.

and if you insert new data also in db .then it will automaticlly get reflected in your table after reload.

hope this helps

Re: Adding an extra heading in pivot table

mansi_dv — Mon, 10 Mar 2014 09:10:11 GMT

Tresesco n Sunil...thanx for the help

Re: Adding an extra heading in pivot table

mansi_dv — Tue, 11 Mar 2014 09:10:41 GMT

The second dimension which I use gets arranged in alphabetical order, what if I want it to get loaded in the load order??

Re: Adding an extra heading in pivot table

tresB — Tue, 11 Mar 2014 09:25:39 GMT

Do you find any difficulty there? In the sort tab, select the dimension and set the sort option accordingly.

Re: Adding an extra heading in pivot table

mansi_dv — Tue, 11 Mar 2014 09:34:53 GMT

Ohh ya thanx...