date

[Dolly123]

i want only year from this column any one help me in qliksense

[Chanty4u]

Hi try this

TEST:

LOAD
mid(TEST,3,4) as year;

LOAD * Inline [
TEST
CP2021-01

];

EXIT SCRIPT;

[sidhiq91]

NoConcatenate
Temp:
Load * Inline [
Year
CP2021-04
CP2021-05
CP2021-06
CP2021-07
CP2021-08
CP2021-09
CP2021-10
];

NoConcatenate
Temp1:
Load Year,
mid(Year,3,4) as New_Year
Resident Temp;

Drop table Temp;

Exit Script;

[Dolly123]

i want year,month and day also in same column

[Dolly123]

i want proper date format dd-mm-yyyy

[MarcoWedel]

i want proper description of how year, month and day can be identified in "CP2021-04"