How to get quarters in a form of Q1 , Q2 , Q3 and Q4 from a date

[pal25]

How to get quarters in a form of Q1 , Q2 , Q3 and Q4 from a date. A sample formula should help.

Need to use this in a bar chart

[eronevil]

i would do this at in script. Nested IF sentense

Table:

Load

Date,

if(date<01.01.2022 and date > 01.03.2022, Q1,

if(date<01.03.2022 and date > 01.06.2022, Q2,

if(date<01.06.2022 and date > 01.09.2022, Q3,

if(date<01.09.2022 and date > 31.12.2022, Q4)))) as quater

From table;

Then in Bar chart add quater in x -axis

-V

[marcus_sommer]

You may do it in this way:

'Q' & ceil(month(DATE)/3) as Quarter

- Marcus

[vinieme12]

Creating a separate calendar table would be good

refer below

https://qlikviewcookbook.com/2015/05/better-calendar-scripts/