Rows to Columns

Tue, 21 Sep 2010 13:06:08 GMT

Hi,

can anybody helpme out to format the data from Rows to Columns

LAN DAte DPD

1 1-jan Current

1 2-jan 0-29

Required Format

LAN 1-jan 2 -jan

1 Current 0-29

Thanks in advance,

Arun

Tue, 21 Sep 2010 13:36:57 GMT

Hi Arun,

I had a similar problem a while ago and Ravi helped me out with these two suggestions:

If you have dates in row- a dimension in your chart, just keep your mouse on that column and drag it across.

You will find a blue color arrow pointing towards column titles.

Take your dragged column to expression area where you will see that Blue arrow has become horizontle pointing left.

Drop cursor / mouse there itself.

Your dates will be horizontaly placed.

#2:

I hope your table/Chart is a "Pivot Chart" and not anything else and also it has got Expression field.

If these two conditions are satisfied then you must get it right.

Convert your chart to Pivot chart form and then try it.

____________

Hope this helps,

topic Rows to Columns in QlikView