ValQ Ideas

How can we improve ValQ?

2

Most of the core valQ users, will be using the “Quick Editor” – exported xls as “template” for reusing the structure as part of their multiple use cases. Right now, it doesn’t store “Navigation Panel” settings as part of it.

It will be great if it does store the “nav Panel” Settings along with tree structure

Posted new comment

Hi nsdevaraj,

Can you clarify what you mean please? The imported Excel template and the quick editor are two different features. The intended function of the quick editor is to remove the need for using Excel templates and permit you to do the same thing in a more streamlined fashion within ValQ itself. Neither contain the NavPanel configuration or current settings though.

You can export a ValQ model from ValQ and preserve the NavPanel settings in the current version (1.1.2)

Right now let’s consider am managing four factories and have similar data structure and same tree config. I can simply use XLS generated from quick editor as template for all my valq reports. But everytime I have to configure NAV panel manually.

I am still not sure what you mean by an XLS generated by the quick editor. The quick editor does not generate XLS data.

Do you mean you are getting your data from 4 XLS sheets and generating a dynamic ValQ model?
If I was using 4 XLS spreadsheets to get my data, there are several different approaches that will get you four different trees based on that. Or you can do one tree that has 4 sub models. Each have the same basic approach.

1. Bring in all 4 XLS to Power BI. Then add a column identifying which spreadsheet the data came from to each table. Give each column the same name.

2. Append the 4 queries as new.

3. Create your ValQ model.

4. Apply a filter to the model to show the aspect you want. OR Create them all within the same tree and use submodel bookmarks to navigate between the 4 different models.

Am not talking about sub models, i do export the tree from quick editor since i can further edit it using excel. If i do export from settings it is neither readable / editable.

The xls exported from quick editor is for a purpose of replacing old legacy template xls. Requirement is simple, old legacy xls does have a sheet to store “nav panel ” setting.

Since its depreciated am asking it to be part of quick editpr xls

Thank you for clarifying. I think I understand now. If I understand correctly you are wanting the “export to excel” button in the quick editor to contain all the features of the model, including the ability to preconfigure the navigation panel. I will add it to the list of feature requests. If I am incorrect in my understanding, please let me know.

0

Is it possible to incorporate excel functions and formulas for nodes in ValQ?

Posted new comment

This is not yet implemented but is planned for a future release. I am currently working on the design and implementation of this functionality. If there are any particular functions you would like us to prioritize your feedback is welcome.