topic Re: Displaying multiple columns in a Pivot table in QlikView

Displaying multiple columns in a Pivot table

Wed, 08 Jan 2014 20:12:15 GMT

Hi - I need help in displaying multiple columns in a Pivot table

Basically I have 2 fields in Dimension and 5 expression. So for every Dimension the pivot table displays 5 rows of data with Amount value.

Now I need to display to display for the same 5 expressions with more columns to the right

Bascially I want to get something like the below -

			Amount	Avg Amt	Amt Variance	Amt Yearly	Amt month
Dim1	Dim2	Expr Field 1	X
		Expr Field 2	X		X
		Expr Field 3	X	X		X
		Expr Field 4	X				X
		Expr Field 5	X
	Dim2	Expr Field 1	X
		Expr Field 2	X		X
		Expr Field 3	X	X		X
		Expr Field 4	X				X
		Expr Field 5	X

Appreciate your help

Re: Displaying multiple columns in a Pivot table

Thu, 09 Jan 2014 06:38:31 GMT

Hi Dimple,

In Pivot Table you can't add dimensions on Right side after expressions. Dimensions always it comes on Left and Expressions will comes on Right. In straight table you can do this,can make arrange on any format but you won't get the Grouping of data and subtotals.

Re: Displaying multiple columns in a Pivot table

sundarakumar — Thu, 09 Jan 2014 07:09:15 GMT

Can you please explain on what columns that you want to add?

i.e the columns that you wish to add betw dim and exp in pivot table.

-Sundar

Re: Displaying multiple columns in a Pivot table

Thu, 09 Jan 2014 07:29:20 GMT

Hi,

Now I need to display to display for the same 5 expressions with more columns to the right

Do you want to add more dimensions or more expressions?

Can you elaborate a little or add a sample app if possible?

Re: Displaying multiple columns in a Pivot table

Thu, 09 Jan 2014 21:15:38 GMT

Thanks I will try to do sample