topic Re: Split data as columns - Quarters in QlikView

Split data as columns - Quarters

Wed, 24 Jun 2015 17:27:23 GMT

Hi Team,

I have a column Quarters which has data like Q1 2015,Q2 2016,Q3 2017 and so on.

i want this to be broken down into columns as Q1, Q2, Q3 and Q4

Please provide your suggestions

Thanks,

maxgro — Wed, 24 Jun 2015 17:32:25 GMT

do you want (script?) the "Q1 2015" value in columns Q1?

load

Quarters,

if(left(Quarters,2)='Q1', Quarters) as Q1,

if(left(Quarters,2)='Q2', Quarters) as Q2,

......

but I don't understand the reason

MarcoWedel — Wed, 24 Jun 2015 23:37:31 GMT

Hi,

do you really want to create separate columns for the quarters?

Or just the quarter information extracted in one column and use this as horicontal dimension in a pivot table?

The latter could be achieved like:

LOAD Left(Quarters, 2) as Quarter
FROM yoursource;

maybe this helps also:

regards

Marco