Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
MVP & Luminary
MVP & Luminary

Re: new to qlikview crosstabs

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
2 Replies
MVP & Luminary
MVP & Luminary

Re: new to qlikview crosstabs

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

Re: new to qlikview crosstabs

Thank you, it's exactly what i needed.