Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Regarding Converting Integer to MMM YYYY format

I have created one pivot/Crosstab file in the excel with the below screenshot. when i import the file into the Load editor i'm able to see the below screen.

SourceFile Format:

Load Editor format :


i'm unable to find the functions of converting the ( 41640,41671,.........) values to the above excel MON-YYYY format in my Table.

Where i want to get the below format after loading.

Need some Date conversation functions to work on these kind of conversations.

Thanks

Rams.

10 Replies
its_anandrjs
Champion III
Champion III

Sample file needed and also complete code from cross table load to final resident load.