topic how to use dimension as a column in pivot table in QlikView

how to use dimension as a column in pivot table

Tue, 05 Apr 2011 08:22:08 GMT

Hello,

I have two dimensions and one measure. I want one dimension to appear as a row, the other dimension to appear as a column, and the measure to be the value for those dimensions. For example

date1 date2 date3 date4

job1 123 456 009 768

job2 678 897 890 788

job3 23 89 8 0

Can someone please guide me how can i give the above presentation to a pivot table/straight table in Qlikview

-Arif

how to use dimension as a column in pivot table

Tue, 05 Apr 2011 08:40:18 GMT

use set analysis in your expressions.

how to use dimension as a column in pivot table

Tue, 05 Apr 2011 09:01:12 GMT

Hello,

Thanks for your reply. I am new to QV. Can you explain how can i use set analysis to perform this task?

Arif

how to use dimension as a column in pivot table

jonathandienst — Tue, 05 Apr 2011 09:47:57 GMT

Arif

Create a normal pivot table with the two dimensions. Then in the table, drag the date dimension header (you'll see a marker when you start dragging) to the top of the table, and the marker will change to horizontal. Drop it there and you will have a cross table.

Hope that helps

Jonathan

how to use dimension as a column in pivot table

Wed, 06 Apr 2011 07:43:03 GMT

Thanks Jonathan,

This is what i want, but i can't drag the column header. I am trying but i am not seeing any marker there. The only marker i can see is the + marker, with which i can extend or narrow the column width. Can you please help

Arif

how to use dimension as a column in pivot table

Wed, 06 Apr 2011 07:53:38 GMT

Hello,

It worked. Thanks

Arif

Re: how to use dimension as a column in pivot table

Sun, 14 Dec 2014 07:41:25 GMT

I have a similar situation. But I am unable to drag and make it a transpose. The blue marker is always vertical and do not change to horizontal.

Using straight table i was able to do, but for Pivot transposing a column to dimensions as column names is not working.

Re: how to use dimension as a column in pivot table

Sun, 04 Jun 2017 03:03:00 GMT

I know this post is old, but as I found the answer I'll share it for anyone else in the future. I had the same problem and was trying to drag the header to the left, but you actually need to drag the header to the right instead. I know that doesn't make sense, but when I dragged the header left all I could get was the vertical blue arrow. When I dragged it over to the right and down a little it would turn horizontal. Hope that helps someone!

Re: how to use dimension as a column in pivot table

ifu98400 — Wed, 01 Nov 2017 11:42:19 GMT

Ken thanks a lot. I couldn't figure this out and your post saved me so much time today with this tip!

Re: how to use dimension as a column in pivot table

FisherShi — Thu, 20 May 2021 08:10:40 GMT

it works. thanks