Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

new to qlikview crosstabs

I would like to create a crosstab. Using a Chart object right now.  I have a dimension of products. I want to show the selected weeks across the top.  Ranging from 1 to 53.  I would like to add a total at the bottom of the dimension and a total accross summing up all the selected weeks.  Not sure how to just show the selected weeks then sum them up giving me a total column.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Create a new chart and choose the Pivot Table as chart type. Add your products field as the first dimension and your weeks field as second dimension. Also add an expression that calculates something, for example sum(Sales). On the Presentation tab of the properties screen check the Partial Sums option for both dimensions. Under Subtotals you can choose if you want subtotals at the top or bottom (for a row dimension that means left or right). You may want to check the option Always Fully Expanded too. The weeks field will be the second column, so you'll have to drag it to above the expression column. This can be a bit tricky. When you see a horizontal blue arrow appear you can let go and the weeks field should be in the right place.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

Create a new chart and choose the Pivot Table as chart type. Add your products field as the first dimension and your weeks field as second dimension. Also add an expression that calculates something, for example sum(Sales). On the Presentation tab of the properties screen check the Partial Sums option for both dimensions. Under Subtotals you can choose if you want subtotals at the top or bottom (for a row dimension that means left or right). You may want to check the option Always Fully Expanded too. The weeks field will be the second column, so you'll have to drag it to above the expression column. This can be a bit tricky. When you see a horizontal blue arrow appear you can let go and the weeks field should be in the right place.


talk is cheap, supply exceeds demand
Not applicable
Author

Thank you, it's exactly what i needed.