topic Re: Date display in calculated dimension in QlikView

Date display in calculated dimension

ipauldur — Mon, 27 Jun 2011 06:37:37 GMT

Hi All,

I want to display the date field in calculated dimension. Actually, i have condition for displaying two different formats.

For example, We have "Type" and "Date" fields. So in the chart dimension, i need to display if field Type='Yes' then Date field value in "DD/MM/YYYY" format. Otherwise in "YYYY/MM/DD" format. Is it possible?

Note: Type field has Alaways one selected value.

Thanks,

Durai.

Date display in calculated dimension

kaushiknsolanki — Mon, 27 Jun 2011 06:43:42 GMT

Hi,

Try this.

if(Type = 'Yes',Date(Date,'DD/MM/YYYY'),Date(Date,'YYYY/MM/DD'))

Regards,

Kaushik Solanki

Date display in calculated dimension

ipauldur — Mon, 27 Jun 2011 06:48:24 GMT

Hi,

Sorry. I tried this one already.But didn't worked..Its showing in julion (40876) format.

In any of one format we can..but need to include condition in the dimension field. After putting "If" condition the value changing into numbers.

Thanks for the suggesstion..Any other suggesstions?

Thanks,

Durai.

Re: Date display in calculated dimension

ipauldur — Mon, 27 Jun 2011 06:48:52 GMT

Hi,

Sorry. I tried this one already.But didn't worked..Its showing in julion (40876) format.

In any of one format we can..but need to include condition in the dimension field. After putting "If" condition the value changing into numbers.

Thanks for the suggesstion..Any other suggesstions?

Thanks,

Durai.

Re: Date display in calculated dimension

kaushiknsolanki — Mon, 27 Jun 2011 06:53:25 GMT

Hi,

Can you upload the document.

Regards,

Kaushik Solanki

Re: Date display in calculated dimension

ipauldur — Mon, 27 Jun 2011 07:12:45 GMT

Hi Kaushik,

Thanks for your reply.

Find the attached document for your reference.

Thanks,

Durai.