Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

chinnu123
Contributor

Hi community,i need double header in straight or pivot table. which is as shown in attached image

can any one pls help me how to achieve this

7 Replies
MVP
MVP

Re: Hi community,i need double header in straight or pivot table. which is as shown in attached image

Yes  you could achieve multiple lines with the Pivot Table. You will have to have a multilevel dimension that will represent the multirow header. In the example I included I have made it artificially by an inline table but this could come from any source also and be connected of course to your data values/measures/metrics:

2015-08-26 #2.PNG

kawamuram
Contributor II

Re: Hi community,i need double header in straight or pivot table. which is as shown in attached image

Hi,

You could combine valueList with dual to make that. I made an example, you just need to change the dimension and the expressions sum's for those you want to use.

chinnu123
Contributor

Re: Hi community,i need double header in straight or pivot table. which is as shown in attached image

Thanks for your reply petter.

  But my data is in excel format. can u please help me in this

MVP
MVP

Re: Hi community,i need double header in straight or pivot table. which is as shown in attached image

Do you have an Excel sheet with your data that you could upload - or a representative sample?

chinnu123
Contributor

Re: Hi community,i need double header in straight or pivot table. which is as shown in attached image

Hi Petter,

See below image,
2nd column i.e May fall under CURRENT field
Overall, April and Monthly% fall under YTD actuals,
and May, April and Trend% fall under Soverign Actuals.

Please help

  Thanks in advance..

image1.JPG

MVP
MVP

Re: Hi community,i need double header in straight or pivot table. which is as shown in attached image

I was thinking about a real XLSX-file - so I dont need to spend time to make test data that you might have already...

chinnu123
Contributor

Re: Hi community,i need double header in straight or pivot table. which is as shown in attached image

can u give your mail id please i will send it to your mail