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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
gireesh1216
Creator III
Creator III

Duplicate Date Format

Hello Team,

I have a date field,i am planing to change date format like MM-YYYY.

Not able to achieve the exact date format.I am getting duplicate date format like below.

Capture.PNG


Please find excel file for raw data.

2 Replies
Frank_Hartmann
Master II
Master II

Maybe like this:

LOAD  MonthName([Comparison Timestamp]) as [Comparison Timestamp],

 

FROM

(ooxml, embedded labels, table is Sheet1);

jobsonkjoseph
Creator III
Creator III

Hi,

is this the output you are looking for;