Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Thank you very much
But i must do so that in qlikview, so the header is displayed?
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
This is a example
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
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
Unfortunately, the new expression will be repeated for each dimension (Monthly, Cumulative in your case), as you got in your qvw.
Eduardo