Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Same header for more than one column

I have the following table

Customer

Customer name

monthly tons

monthly sales

cumulative tons

cumulative sales

I want créate the following table:

                                                          Monthly                Cumulative

Customer     Customer name        Tons      Sales       Tons       Sales

As i define headers Monthly and Cumulative?

1 Solution

Accepted Solutions
eduardo_sommer
Valued Contributor

Re: Re: Same header for more than one column

I modified your example toshow you my idea.

I included an inline load for the Monthly/Cumulative dimension and created a new Pivot table object.

Eduardo

7 Replies
eduardo_sommer
Valued Contributor

Re: Same header for more than one column

You can use a calculated dimension for Monthly and Cumulative and expressions for Tons and Sales, like I did in the pivot table below:

Pivot example.jpg

Eduardo

Not applicable

Re: Same header for more than one column

Thank you very much

But i must do so that in qlikview, so the header is displayed?

eduardo_sommer
Valued Contributor

Re: Same header for more than one column

Hi Preciliano

The table above was created using QlikView. Definining the Pivot Table, I used Customers as the first Dimension and a Valuelist('Monthly','Cumulative') as the second dimension (calculated). When the chart was displayed, I moved the second dimension to the right to be displayed as columns.

In the presentation tab, I defined the alignment of the data and labels.

In the expressions you need to make reference to the dimension to make the proper calculations (for monthly or Cumulative).

If this explanation didn't make it clear to you, I can recreate the app and upload it.

Let me know if this answered your question.

Eduardo

Not applicable

Re: Same header for more than one column

This is a example

eduardo_sommer
Valued Contributor

Re: Re: Same header for more than one column

I modified your example toshow you my idea.

I included an inline load for the Monthly/Cumulative dimension and created a new Pivot table object.

Eduardo

Not applicable

Re: Re: Same header for more than one column

Eduardo.

What happens if i add other columns

                                                                          Monthly          Cumulative

Year  Customer  Name     Any expression    Tons    Sales     Tons    Sales    Factor X

2013                                                                 30      3000        34      34000

            1055        xxxxxx         0.1                    10      1000        12      12000       5

            2012        yyyyyy         0.2                    20      2000        22      22000       7

Thanks

eduardo_sommer
Valued Contributor

Re: Re: Same header for more than one column

Unfortunately, the new expression will be repeated for each dimension (Monthly, Cumulative in your case), as you got in your qvw.

Eduardo

Community Browser