How to pivot the data of rows into columns

[#1]

Hi All,

I have a table where data will be like

But i want my data to be like

Location Num      Week       Sales

3013                  week1         2448

3013                  week2         2513

3020                  week1         3957

3020                  week2          3673         

And so, on .I have attached my QVW. Can someone help me with any suggestions ?

Thanks         

[gmoraleswit]

Check this link: http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/24/crosstable

[#3]

What you need is a dimension "week"  that has "week1" and "week2" as fields

Then make your pivot table with "location num" and "week" as dimensions, and then use "sales" as your expression.

Or you could use a cross table, there are just different options

[#4]

Find the attached document

[#5]

Just drag the Week column from the column section to the rows. Hope it helps you.

[#6]

Can you try something like this in your load script.

LOAD D AS LocationNum, 

    BR AS Week1,

      BS  AS Week2,

      BT AS Week3,

      BU  AS Week4,

      BV  AS Week5,

      IF (BR = Week1,'1',

     IF (BS=Week2,'2',

     IF (BT = Week3, '3',

     IF (BU = Week4,'4',

     IF (BV = Week5,'5'))))) as week

from xyz;

[#7]

Try

LOAD D AS LocationNum, 

    BR AS Week1,

      BS  AS Week2,

      BT AS Week3,

      BU  AS Week4,

      BV  AS Week5,

      IF (BR = 'Week1','1',

     IF (BS='Week2','2',

     IF (BT = 'Week3', '3',

     IF (BU = 'Week4','4',

     IF (BV = 'Week5','5'))))) as week

[#8]

post your qvw here

[dmac1971]

Yep drag and drop is all that is needed here.

[lironbaram]

hi

have a look at the attach example