topic Re: Format Column values in QlikView

Format Column values

Mon, 04 Feb 2013 05:20:52 GMT

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

Re: Format Column values

khadeer — Mon, 04 Feb 2013 05:41:39 GMT

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.

Re: Format Column values

Anonymous — Mon, 04 Feb 2013 05:44:25 GMT

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.)

Re: Format Column values

karthickv — Mon, 04 Feb 2013 05:47:43 GMT

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.