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!
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.
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
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.
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
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
I have a question about the new Expand or collapse grid rows option. Is it possible to publish a grid containing a 5-level hierarchy so that all items from levels 1 and 2 are always visible? And I do not want to use a filter for this.
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
