Format Column values

[#1]

Hi

I am new to Qlikview. I would like to know if there is any way to split the date column as year, quarters (Q1,Q2,Q3,Q4) based on the months at the time of loading.

Also would like to know if I could change the vvalues (Y as Yes, N as No ) at the time of loading of the data.

Any suggestions ??

[khadeer]

Yes, u can split the date field as year, quarter n months,

u can also change the values Y as Yes n N as No

for this if(ur fieldname='Y','Yes',if(ur fieldname='N','No'))

Post ur date sample.

[Anonymous]

Hi,

You can use Year(Date) as Year, and 'Q' & Ceil(Month(Date)/3) as Quarter.

For changing Y/N to Yes/No you can use: if(Fieldname='Y','Yes', 'No') as Fieldname

(Assuming it only has Y/N values.)

[karthickv]

Hi Senthil ,

For Year and Quarter ,

if(left(QuarterName(FIELDNAME),7)='Jan-Mar','Q1',

if(left(QuarterName(FIELDNAME),7)='Apr-Jun','Q2',

if(left(QuarterName(FIELDNAME),7)='Jul-Sep','Q3',

if(left(QuarterName(FIELDNAME),7)='Oct-Dec','Q4')))) as Quarter,

Year(FIELDNAME) as Year

For changing values ,

if(FIELDNAME='Y','YES','NO') as FIELDNAME .

Pls replace FIELDNAME with your respective Date column .

Hope this would help you ..

Regards,

Karthick V.