Filter on quarter time period in an input field

Hello, I have created a quarter time field on a ux page. I can select all quarters in that field. I now want to be able to only select the Q2 and Q4 quarters for that input field on the ux page. How? Thanks! Kind regards!

Accepted answers

All comments

devrathahuja

Hi @filipsneyers ,
You cannot restrict the native time dropdown.

You can either use a custom list for it or since in this case it is just 2 quarters, use 2 booleans instead as View Q2? View Q4? & formulate the filter accordingly.

filipsneyers

ok, thanks, that last option, I don not entirely understand. Can you explain in detail? I have created a line item "only Q2 et Q4" as a boolean : IF LEFT(NAME(ITEM(Time)), 2) = "Q2" OR LEFT(NAME(ITEM(Time)), 2) = "Q4" THEN TRUE ELSE FALSE but this is a boolean and i want a list line item with this filter

asarna

Hey @filipsneyers ,

I guess you're looking something similar (attached picture) - if yes, then create a SYS module and formula for filtering the quarters, that's it!!

NOTE: Q2 and Q4 are visible by filters and not by Show/Hide in NUX page.

Kanishq17

Hello @filipsneyers

You can do two ways ,

One , create a filter for the time period to show in another system module and mark Q2,Q4 , then in UX page apply that filter to show only relevant time period to chose from

Alternately , you can create a DCA for write based on boolean check and apply DCA on the target module (which is input for UX) , so it will mark Q1 , Q3 as read only and Q2 , Q4 to write

Thanks

Kanishq

Quick Links

Can you help?

Unanswered questions

Azure SQL Connection, database name with Hyphens in Data Orchestrator
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
12.4.1 Activity: Create Saved View for Non Employee Expenses
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…