Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Report

The Qlikview Pivot Table object provides for grouping and subtotals.

-Rob

View solution in original post

4 Replies
MVP & Luminary
MVP & Luminary

Report

The Qlikview Pivot Table object provides for grouping and subtotals.

-Rob

View solution in original post

Not applicable

Report

Hi Rob,

Thank you for your replied. You mean, we can do the grouping by drag column to make it first column? And do the subtotals by Properties>Presentation>check "Show Partial Sums"? If yes, how about if I would like to show the subtotals of any grouping column without showing the subtotal of second, third columns, how can I do that?

Cheers,

Jack

MVP
MVP

Report

Yes, you can drag columns around in a pivot table. The show partial sums checkbox is specific to the column in a pivot table, so you can specify which columns should have subtotals, and which do not need subtotals.

Yes, you can create headers and footers. You can specify headers and footers associated with printing any particular chart. For display on the screen, if the chart itself can't do the header you want, you can always add headers and footers as separate objects. There's also a specific reporting component to QlikView that I've frankly never used (not a fan of static, printed reports, and I don't want my users looking at their data that way either), but I'd be shocked if it didn't handle something as basic as headers and footers.

Not applicable

Report

John, Thank you for your help.

Cheers,

Jack