topic Re: How to make column data as headers in straight table in QlikView

How to make column data as headers in straight table

Tue, 20 Jun 2017 21:25:34 GMT

I am importing the data from smartsheet, and for one of the column information i need to make headers

For Eg:

Project Name TG1 TG2 TG3

A 10 20 30

B 30 40 60

Attaching the qvw file, did someone come across similar scenario?

Re: How to make column data as headers in straight table

vishsaggi — Tue, 20 Jun 2017 21:30:14 GMT

Is this what you are looking for?

Check attached. Using Pivot table you can shift the columns to headers.

Re: How to make column data as headers in straight table

Tue, 20 Jun 2017 21:35:45 GMT

Yes this is what i wanted, but how did you drag that field after creating pivot? could you please elaborate it a bit?

Re: How to make column data as headers in straight table

vishsaggi — Tue, 20 Jun 2017 21:39:18 GMT

Once you add dimensions in pivot chart. Just select the dimension you want to drag, hold the mouse key and move the field like below. Click on TG and then holding the key on mouse you can move to top or left, based on the movement the blue arrow changes its direction. Hope this helps.

Re: How to make column data as headers in straight table

Tue, 20 Jun 2017 21:51:54 GMT

Hey Thank you very much it worked, i actually have to drag all the way to the end, then the horizontal line appears.