topic Re: how can i split the column? in QlikView

how can i split the column?

Tue, 23 Jun 2015 17:51:45 GMT

I have excel file with column QTR which contains all quarters but when i am loading into the qvw, I want that to be in each quarter in different column.

like below image in final qvd file

Re: how can i split the column?

ramoncova06 — Tue, 23 Jun 2015 18:22:43 GMT

you should not split that data that way, instead use a pivot table and drag drop you quarter field to the top

Re: how can i split the column?

MarcoWedel — Tue, 23 Jun 2015 18:32:37 GMT

Hi,

you could load the quarters like:

tabQuarters:
LOAD *,
    Dual(Quarter_txt,MakeDate(Right(Quarter_txt,4),Mid(Quarter_txt,2,1)*3-2)) as Quarter
INLINE [
    Quarter_txt
    Q1 2015
    Q2 2015
    Q3 2015
    Q4 2015
    Q1 2016
    Q2 2016
    Q3 2016
    Q4 2016
];

and use in pivot tables as already suggested.

hope this helps

regards

Marco

Re: how can i split the column?

MarcoWedel — Tue, 23 Jun 2015 20:52:17 GMT

Hi,

one example:

hope this helps

regards

Marco

Re: how can i split the column?

Wed, 24 Jun 2015 03:18:10 GMT

Hi Marco,

Could you pleases share the qvw file as I am unable to repro the same

Thanks

Re: how can i split the column?

MarcoWedel — Wed, 24 Jun 2015 05:15:50 GMT

Already attached, please try again.

Regards

Marco

Re: how can i split the column?

sasiparupudi1 — Wed, 24 Jun 2015 06:40:07 GMT

Re: how can i split the column?

Wed, 24 Jun 2015 14:29:47 GMT

to Sasidhar,

how can we achieve it?

Re: how can i split the column?

sasiparupudi1 — Wed, 24 Jun 2015 16:46:15 GMT

The field can be split as follows and rest is dependent on how you want your data to look like

LOAD

SubField(Quarter_txt,' ',1) as Quarter,

SubField(Quarter_txt,' ',2) as Year

INLINE [

Quarter_txt

Q1 2015

Q2 2015

Q3 2015

Q4 2015

Q1 2016

Q2 2016

Q3 2016

Q4 2016

];