topic Pivot Table - Format in QlikView

Pivot Table - Format

pkelly — Fri, 22 Oct 2010 11:27:30 GMT

Hi All

I am trying to acheive the following format in a pivot table...

	Product	Product A		Product A
Customer		Var Value	Var %	Var Value	Var %
CustomerA	Sales
	Gross Profit
CustomerB	Sales
	Gross Profit
CustomerC	Sales
	Gross Profit

The only way I can see to do this is to create a stand alone table with my Var Value and Var% as fields.

Is there another (easier) way of doing this from within the pivot table...

EDIT:

Second product column should read product B

Regards

Paul

Pivot Table - Format

pkelly — Fri, 22 Oct 2010 16:04:08 GMT

Any ideas?

Pivot Table - Format

Mon, 25 Oct 2010 13:44:13 GMT

It is a matter of dragging your dimensions and expressions into the right place. See attached

Pivot Table - Format

pkelly — Mon, 25 Oct 2010 16:01:31 GMT

Thank you - whilst this is close it is not the layout which I am looking for...#

For sales and gross profit I want to see Var Value and Var % for each product.

Any help greatly appreciated...

Pivot Table - Format

Oleg_Troyansky — Sun, 14 Nov 2010 17:24:33 GMT

I realize it's a bit late, but...

- You can create a calculated dimension using function Valuelist() and condition your expressions based on the value. For example:

Dimension = ValueList('Var Value', 'Var %')

Expression:

if ( ValueList('Var Value', 'Var %') = 'Var Value', sum(Sales), sum(Sales)/sum(Total Sales))

As a side comment - I'd challenge this sort of presentation where you show both Sales and GP, and both are presented as values and as %. In my opinion, the table becomes too busy and hard to read. I'd look for a better way to visualize this information.

Pivot Table - Format

pkelly — Thu, 09 Dec 2010 10:11:48 GMT

Thanks Oleg - I will give it a go...

Agree with you 100% on the presentation but this is the layout our user wants to see.