topic Re: Multiple Headers in QlikView

Multiple Headers

Wed, 29 Aug 2012 13:32:00 GMT

Hello Friends,

As I need to create a pivot table using the format as in the attached.

Regards

Chriss

Re: Multiple Headers

Wed, 29 Aug 2012 13:57:17 GMT

You can "fake it" using text boxes. See attached.

Re: Multiple Headers

Thu, 30 Aug 2012 07:05:19 GMT

Hi,

Thanks for your reply, I have done it through text object only but the customer wants on selection of Year the value has to display, for this any workaround ...

Regards

Chriss

Re: Multiple Headers

Anonymous — Thu, 30 Aug 2012 11:30:17 GMT

Hi,

Looks like a standard pivot table to me.

Create a chart of type Pivot, with 2 dimensions (PAID/REDFLAG and MonthName) and two expressions (Amount sum and Shipment # count). Drag MonthName from column 2 across to the right, so that a vertcial blue column placement line appears, then drop it.

Total row can then be achieved by selecting Show Partial sums (from presentation tab) for the PAID/REDFLAG column, and set as the first line by choosing Subtotals on Top (from presentation tab again).

Regards,

Jonathan

Re: Multiple Headers

Thu, 30 Aug 2012 14:28:19 GMT

The text can be based on the selection. Take a look at the attached example.

Re: Multiple Headers

Anonymous — Thu, 30 Aug 2012 14:48:33 GMT

Example attached that sets up a Pivot table and doesn't need any fake text labels. Label can then be clicked on to select that Month, and drill down to underlying dates if available at that level.

Jonathan