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?
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
Retail Knowledge | Detecting Trend INTRODUCTION Using machine learning to detect a sales trend is a science and an art. Obviously no computer program or set of calculations could ever know everything that’s going on with your business. The creative side of detecting a trend is built upon your familiarity with the way your…