Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
You may do it in this way:
'Q' & ceil(month(DATE)/3) as Quarter
- Marcus
Creating a separate calendar table would be good
refer below
https://qlikviewcookbook.com/2015/05/better-calendar-scripts/