Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlikhub
Contributor III
Contributor III

date

Qlikhub_0-1655295792995.png

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

 

Labels (5)
5 Replies
Chanty4u
MVP
MVP

Hi try this

TEST:

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

LOAD * Inline [
TEST
CP2021-01

];

EXIT SCRIPT;

sidhiq91
Specialist
Specialist

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;

Qlikhub
Contributor III
Contributor III
Author

i want year,month and day also in same column

Qlikhub
Contributor III
Contributor III
Author

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"