Script to change column width of an item or all items
This script designed to change the column width of items.
Similar Posts
Willkommen in der Welt der mehrdimensionalen Finanzmodellierung
Dieser Artikel wurde im größten Fachportal für Controller im deutschsprachigem Raum – CONTROLLING-Portal.de veröffentlicht. Link zu Fachbeitrag In diesem Artikel wird eine neue, innovative Methode zur Finanzmodellierung für Ihre Planung, Budgetierung, Prognose und Durchführung von Was-wäre-wenn-Analysen mit mehreren Szenarien vorgestellt. Jeder Controller steht in seiner täglichen Arbeit vor komplexen Modellierungsaufgaben. Bereit sich auf den Fahrersitz zu…
Use new $RoleName variable to create views assigned to each role
I think the most interesting way of using role names is in creating different views of the same Matrix based on the role. This means users with different roles will see different parts of the matrix assigned to them. We can do it by using the role name variable in filter expression. You save your…
Enhanced Filtering in Quantrix: Leveraging the ALL Dropdown and Improved UI
To enhance the filtering process and provide an option to show all items, user can consider adding an “ALL” item to the dropdown list (this can be done via concatlist() or the generate items feature). When a user selects “ALL,” the entire table will be displayed. This approach may be more intuitive for users, as…
Welcome to the world of Multidimensional financial modelling
This article will introduce you a new, innovative way of financial modelling for your planning, budgeting, forecasting needs and running “what-if” analysis with multiple scenarios. Every controller faces complex modelling tasks in his/her daily work. Be ready to sit on driving seat, quickly and efficiently create your financial model. Multidimensional modelling is an alternative to…
Reorder items via script in Quantrix
It is possible to reorder items based on values via script (an example shown below). It should be clear that in a sorted matrix, Quantrix sees only original (unsorted) item position (index). One can check it by adding item with #category formula in the sorted matrix. So, concept of sorting and reordering somehow different.
“Revolutionary new program that may wind up stealing the show” – LA Times
This almost 30 years old article promises that Lotus’ Improv for Windows will change the way people create and look at spreadsheets. With Excel dominating the market, these amazing advantages of Lotus Improv are almost forgotten. But they are still valid today.Luckily, we have all these amazing concepts of Lotus Improv in Quantrix for those who want…
