Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
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.
dunnalahk123
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
Channa
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

Channa
pradosh_thakur
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.