Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
dunnalahk123
Creator III
Creator III

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
Specialist III
Specialist III

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

Channa
pradosh_thakur
Master II
Master II

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

Please don't duplicate thread.

Learning never stops.