Hi,

not sure if this is what you mean with a quarterly filter but you can try it like this:

FILTER (QUARTER("BKPF"."BUDAT") = CASE WHEN QUARTER(TODAY()) = 1 THEN 4 ELSE QUARTER(TODAY())-1 END AND YEAR("BKPF"."BUDAT") = CASE WHEN QUARTER(TODAY()) = 1 THEN YEAR(TODAY())-1 ELSE YEAR(TODAY()) END)

This is one example out of Accounts Payable based on BKPF.BUDAT compared with TODAY() to show the data from last quater.

Hi,

I have added the quarterly filter in dashboard ,But i am not getting proper count can you please help me out .for

how add quarterly data with PQL query

Hi,

I am still not sure if I get you right. Maybe you can explain it in more detail or share some screenshots.

But you can try the following and sure maybe there is a much easier solution for your request. But here is how I would solve it:

Create a drop down that will be used as filter with a similar logic like this:

'0' || TO_STRING(QUARTER(BSEG.BUDAT)) || ' - ' || TO_STRING(YEAR(BSEG.BUDAT))

Use Load Entries and write your selection into a variable.

e.g you select 02-2021 and this is now the value shown within your selected variable.

*You can also think about using two different drop downs. One for selecting a quarter and another one to select the year.

By the way select "Component is not filtered with selections" on your drop down(s)

Add another two variables in order to get the quarter of your date field and the year of your date field. e.g:

variable quarter:

'0' || TO_STRING(QUARTER(BSEG.BUDAT))

variable year:

TO_STRING(YEAR(BSEG.BUDAT))

Now add the following filter to your sheet or component filter:

FILTER <%=quarter%> = SUBSTRING('<%=filter_variable%>', 0,2);

FILTER <%=year%> = SUBSTRING('<%=filter_variable%>', 5,4);

BR

Dennis

Hi

Thank you for the help

If you have no issue, then we can connect,