Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to get Date format in Calculated dimension

Hi,

I'm having difficulties to get the calculated dimensions as Date format  (mm.yy). The natural results is number.

I would like to know how to Text format to be in the date format.

here it is the details of the issue:

Calculated dimension:

5-05-2014 3-22-44 PM.png

results:

5-05-2014 3-23-06 PM.png

Thanks in advance, Leandro

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: How to get Date format in Calculated dimension

use Date(DateFormated,'MMM/YY') in your calculated dimension

2 Replies
Not applicable

Re: How to get Date format in Calculated dimension

use Date(DateFormated,'MMM/YY') in your calculated dimension

Re: How to get Date format in Calculated dimension

Hi

try below

=date(date#(Datefield),'DD/MM/YYYY'),'MMM/YY')

Note:

make sure to 'DD/MM/YYYY' replace with your date time stamp.

hope it help.

Regards

ASHFAQ

Community Browser