Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
gireesh1216
Creator II
Creator II

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;