topic Re: Same header for more than one column in QlikView

Same header for more than one column

Tue, 13 May 2014 02:51:23 GMT

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?

Re: Same header for more than one column

eduardo_sommer — Tue, 13 May 2014 03:25:38 GMT

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

Eduardo

Re: Same header for more than one column

Tue, 13 May 2014 14:13:48 GMT

Thank you very much

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

Re: Same header for more than one column

eduardo_sommer — Tue, 13 May 2014 14:30:18 GMT

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

Re: Same header for more than one column

Tue, 13 May 2014 15:24:27 GMT

This is a example

Re: Re: Same header for more than one column

eduardo_sommer — Tue, 13 May 2014 17:09:40 GMT

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

Re: Re: Same header for more than one column

Tue, 13 May 2014 17:53:27 GMT

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

Re: Re: Same header for more than one column

eduardo_sommer — Tue, 13 May 2014 18:47:18 GMT

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

Eduardo