topic Report in QlikView

Report

Wed, 07 Apr 2010 08:25:23 GMT

Is it possible to create a complex report (like Crystal Report) on the QlikView? Ex. group by, sub-total, multi sections(Header, Detail, Footer)?

Cheers,

Jack

Report

rwunderlich — Wed, 07 Apr 2010 09:16:22 GMT

The Qlikview Pivot Table object provides for grouping and subtotals.

-Rob

Report

Wed, 07 Apr 2010 09:30:31 GMT

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

Report

johnw — Thu, 08 Apr 2010 02:14:14 GMT

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.

Report

Thu, 08 Apr 2010 04:08:52 GMT

John, Thank you for your help.

Cheers,

Jack