Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

h_prakash
Contributor

Format a Date Field as MMM-YYYY in Qlik Sense

Hi Qlik Experts,

I have a Date Field which is in MM/DD/YYYY Format. I wanted to format the Field as MMM-YYYY.

I am using this field in Table with some more dimensions like Project Status. And I wanted to Show the Values of the Date Field when the project status is Active if not it should have blank values. Iwhen I write Expression in the Date Dimension field as

Date(if(Project Status = 'Active', Date),'MMM-YYYY'). It is working as expected but the when Users export it is not showing as numeric values and it is treating as string. I tried this way also but it is not working if(Project Status = 'Active', Date(Date,'MMM-YYYY')...

Please help in this regard.

Thanks

Hari

Tags (1)
1 Reply
lgutierrez
New Contributor III

Re: Format a Date Field as MMM-YYYY in Qlik Sense

Hi Hari

you can use the funtion

monthname('19/10/2013', -1)

Devuelve Sep 2013.

regards.

Community Browser