topic Re: pivot columns like straight table in QlikView

pivot columns like straight table

Mon, 17 Jun 2013 10:20:33 GMT

Hello

I have this situation in a Pivot table:

HouseName, Products, COSTS

A CHEESE 2

BLALGLA 4

JSDOASJD 4

SJDASDJ 5

B HEHEHE 2

UHLHLA 2

And so on.

How can i do so i would be like this, and i also want to remove my Sum column, I know i cannot hide columns, but can i show the dimensions without having an expression?:

HouseName

A B

CHEESE HEHEHE

BLABLGA UHLHLA

Or is it possible in a straight table??

Re: pivot columns like straight table

Gysbert_Wassenaar — Mon, 17 Jun 2013 19:00:26 GMT

See attached qvw for two options.

Re: pivot columns like straight table

Tue, 18 Jun 2013 09:15:33 GMT

Cheers! Do you know if it is possible to change the cell height for only the products?

If i turn of the cell height to example 20. Both will be 20, and then there will be a lot of white space.

And how do i make an autonumber if my Cost is coming from another table?

Re: pivot columns like straight table

Tue, 18 Jun 2013 10:55:23 GMT

Sorry i corrected your answer - can you maybe tell me how to fix what i wrote in my message before this post?