Very new to Qlikview having migrated from 10 year old Cognos [7.1]
Having problems visualising how to get data in simple cross-tab forrmat with a list of dates across the top, products down the left and values within the data [as below, manually entered so excuse the formatting]
Header 1
2012 Apr
2012 May
2012 Jun
2012 Jul
2012 Aug
2012 Sep
2012 Oct
2012 Nov
2012 Dec
2013 Jan
2013 Feb
2013 Mar
MAT
Product 1
1.3
4.3
5.3
2.0
3.8
1.8
2.5
1.8
1.8
24.3
Product 2
0.4
0.5
0.9
Product 3
1.8
0.6
3.1
4.0
3.7
2.4
3.1
18.6
and so on ...
1.5
6.0
7.5
3.0
18.0
Totals
0.0
0.0
0.0
4.6
11.3
12.8
5.0
6.8
5.7
6.2
4.2
5.2
61.8
Apologies if this is a simple question and I’m sure it has been asked many times before but I cant see it easily in the history.
My data source consists of single flat invoice analysis file that’s has all the required information in: Product, Year.Period and Qty as well as Customer so I can apply filters
Any help, even if its just pointing me to the same question previously asked and now answered, would be greatly appreciated
Add a new chart object and choose as chart type the pivot table (top right of the Chart Type icons). Add Product and Year.Period as dimensions and something like sum(Qty) as expression. Next you'll have to drag the Year.Period dimension to the right above the expression. When you see a horizontal blue line let go and the Year.Period dimension should now display horizontally. On the Presentation tab of the properties window you can select both dimensions and enable the option Show Partial Sums.
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
Add a new chart object and choose as chart type the pivot table (top right of the Chart Type icons). Add Product and Year.Period as dimensions and something like sum(Qty) as expression. Next you'll have to drag the Year.Period dimension to the right above the expression. When you see a horizontal blue line let go and the Year.Period dimension should now display horizontally. On the Presentation tab of the properties window you can select both dimensions and enable the option Show Partial Sums.
