Filter a dimension by the value that is saved today.

[Richard3]

I need to filter a dimension by the value that is saved for today.
For example:
I have the quarters of the year identified by my fiscal year that begins in October, that is, October, November and December belong to Q1. January, February and March belong to Q2. April, May and June belong to Q3. July, August and September, belong to Q4.
Therefore I need you to bring me the current Q depending on what month we are in.

[QFabian]

Hi @Richard3 , yo can create a INLINE table linked by your month field:

Quarter:

Load * INLINE [

Month, Quarter

1, Q1

2, Q1

3, Q1

4, Q2

5, Q2

6, Q2

7, Q3

8, Q3

9, Q3

10, Q4

11, Q4

12, Q4

];

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFun...

[Richard3]

I created the table as you told me, but I can't get it to bring me the Q (four-month period) of the current month, could you explain to me now how I would make the call for the current month?

[QFabian]

Sure, you have to nme the date field in the INLINE LOAD with the same name of your Month date. With that, there will be a relation between the quarter table and the table where the month field exists. So, when you clic on a month, it is going to show you the related quarter