Date to month-quarter-year

[cmano]

Hello guys.
I am new at this so i need a detailed description.

I have and excel file with dates likes these: 01-01-2020  - 28-02-2021.

How i convert these dates in quarter-month-year?

I want to make make some filters (pic below) at qlik as month and quarters and years.

Thanks in advance.

Attached image

 

[sergio0592 · Accepted solution]

Hi,

In your load statement, use month and year function:

LOAD 
Year(Date) as Year,
Month(Date) as Month, 
ceil(Month(Date)/3) as Quarter, 
Ventes
FROM
[C:\Users\xxxx\Desktop\Test.xlsx]
(ooxml, embedded labels, table is Feuil1);