Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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

1 Reply
Highlighted
Contributor III
Contributor III

Hi Hari

you can use the funtion

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

Devuelve Sep 2013.

regards.