Hello! How can I create a filter like this one where the user can select what to filter?
Create a list formatted line item then make that in a module with no dimension. Then create the same list formatted line item in main module where you want to use this filter. And put formula in that lineitem: "If ISNOTBLANK(No dimension Module.Lineitem) then Main module.lineitem = No dimension Module.lineitem" else False.
Hope this helps!
You can see this filter on NUX by placing a field card on page then source it to No Dimesion Module. And don't forget to apply the filter on main module.
One more question: currently the module view does not change immediately when I change de option in the filter - I have to refresh the page to see the changes. Is there a way to solve this?
You can create a button to Refresh the page named as Apply Filters. Use Action card> Data Write> Select Boolean line item.
Create a boolean lineitem with no dimension and reference that lineitem in your Action card. This button can be used to refresh the page.
Change Year Lineitem to dependent on Cycle.
Create a property in Cycle list> format it to the Year list>Click on format of Year lineitem in module> Check the Dependent checkbox > Select Cycle list and the property from dropdown.
@vermssilva You are checking at Configure actions on Card. Drag and drop the Action card and edit it then you'll be able to see the Data Write option.
Hi @vermssilva
For your below question , pls find find the below solution (Answer ):
Question: I have another question: when using two filters, how can I establish a relationship between the options given in the second filter and the selection made in the first?
Example in the image: [ considering the hierarchy: Year Β» Cycle (Parent) ]
If I choose 1st Cycle, whose children are 1st, 2nd, 3rd, and 4th Year, it should not be possible to choose 5th Year.
Answer:
U need to on dependent dropdown from the backend. To activate dependent dropdown , Follow the below steps:
3) Choose the first line item , circle. It will show according to 1st selection.
Hope that helps.
Regards
Ashutosh
Thank you very much @umangsinghal this was a great help!
Thank you very much! I have another question: when using two filters, how can I establish a relationship between the options given in the second filter and the selection made in the first?
Thank you so much this worked perfectly. About the "Refresh Button" I do not have the option to create a data write action in my interface, is this common? Am I looking in the wrong place?
I am trying to create a Net Debt / EBITDA formula at the bottom of one of our P&L income statements where, i have tried the MOVINGSUM function. However this does not work for summary line items which EBITDA is. What i would like is to be able to sum the previous 12 months EBITDA (Including the current period) numbers in aβ¦
I have this template to import back to my module By right it should match the module because the time format is the same as the module the only difference is that in the excel file there is a seperator. M-Y. Thus logically to me it should be But when i run the action using M-Y and match names both result in an import errorβ¦
Hi everyone, I was trying to Retrieve a Line Item (Boolean) using TIMESUM as formula to another module by using ANY. This Boolean LI has A,B,C as dimensions. My target module has only A as dimension. In order to use a reference module for mapping, does this reference module had to have A,B and C as dimension or just Aβ¦
