Cross table - Split single column into two values

[#1]

Hi All

There is single column.. Planned Preinduction meeting date.

I wanted to show that in attached file manner

                Pre induction date

Planned    21/02/2011

how to split the record in pivot table ??

[stephencredmond]

Hi,

Not sure exactly what you are looking for but if you have more than one expression, you can pivot them around to the vertical axis.  Does that meet your requirements?

Regards,

Stephen

[#3]

Hi stephen

it is not expression... it is raw field from database. Field name should be separated..

planned induction date in database = 21/02/2011.

it has to be separated as vertically half and horizontally half.

is that something like we should use while loop to iterate the value ??

[stephencredmond]

Hi,

You can do that.

Be careful though.  QlikView is not about creating pixel perfect tabular reports so there are limitations.

Regards,

Stephen

[#5]

Thanks stephen for your reply.

But intersection of two columns the data should be present.

This is wat client is requesting. Is there a way.. can we hardcode a value ' Plan' and do a while loop ??

need experts advice...

Any other idea ?? pls share