topic Re: Cross table - Split single column into two values in QlikView

Cross table - Split single column into two values

Wed, 15 Feb 2012 13:51:20 GMT

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 ??

Cross table - Split single column into two values

stephencredmond — Wed, 15 Feb 2012 14:21:05 GMT

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

Re: Cross table - Split single column into two values

Wed, 15 Feb 2012 14:36:55 GMT

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 ??

Re: Cross table - Split single column into two values

stephencredmond — Wed, 15 Feb 2012 14:50:28 GMT

Hi,

You can do that.

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

Regards,

Stephen

Re: Cross table - Split single column into two values

Wed, 15 Feb 2012 15:06:30 GMT

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