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?
Hi, I have a module with a time range as a dimension. I've set it with a daily time scale, but Anaplan's way of showing daily dates is for example "1 Jan 37" and I need it to be in numbers because when I export it excel doesn't recognize it as the date format that I've set in Windows (OS) (when a date as two digits it'sā¦
Hi All, I want to address an query related to exports, In Output model, which is read access for all users & roles.user want to have dynamic export depending on user selection of multiple regions. So for selected regions , they will be able to see the data only for selected regions. Thanks,
Kindly assist me to load data into the model.
