Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Contributor II

Month format

Hi ,


Can some one help me with my month Format


In my month Filter i am getting values as per below snapshot


like 43252 but i need everything should be like "201711" format


This is happening because when i source data from different Sources for different KPI's few of the KPI's month is coming like 43252 etc. but i need my month filter with values like 201711 foramt


Month Format.PNG

2 Replies
Valued Contributor III

Re: Month format

while loading just add Date(Month) it will convert number to date later you can define format 'YYYY-MM' or YYYYMM

Honored Contributor II

Re: Month format

if(len(Month)=6,date(date#(text(Month),'YYYYMM'),'YYYYMM'), DATE(Month,'YYYYMM'))

Please don't duplicate thread.

Learning never stops.