ValQ - Plan
FormulaProductChangelogStart Trial
  • Introduction to ValQ
    • Get ValQ
    • The ValQ Workflow
  • Model
    • Get Data
    • Create Model
      • Dynamic Model
      • Custom Model
      • Import a Model
    • Model Editor
      • Node Operations
      • Editor Features
    • Node Settings
    • Templates
      • Apply Template
      • Manage Template Nodes
      • Import Template
      • Export Template
    • Formula Functions
      • Logical Functions
        • IF
        • SWITCH
        • AND
        • OR
        • NOT
        • XOR
        • IFNAN
      • Math Functions
        • SUM
        • SUBTRACT
        • PRODUCT
        • DIVISION
        • AVERAGE
        • AVERAGEEXZERO
        • AVERAGEEXNEG
        • AVERAGEEXZERONEG
        • COUNT
        • ABS
        • MIN
        • MAX
        • POWER
        • SQRT
        • EXP
        • LOG
        • ROUND
        • FLOOR
        • CEILING
      • Finance Functions
        • IRR
        • NPV
        • PMT
        • IPMT
        • FV
        • PV
        • CUMIPMT
        • CUMPRINC
        • RATE
      • Range Functions
        • RANGE
        • LastNPeriods
        • Get
        • ForEach
        • findByTitle
        • GETCURRENTRANGE
        • GETROWVALUE
        • THIS_SOURCE_KEY
        • PERIOD_LOOKUP
        • PRIOR_SERIES_PERIOD_LOOKUP
      • Static Identifiers
        • THIS/ME
        • CURRENT_SERIES*
        • CURRENT_SERIES_ID*
        • CURRENT_PERIOD_INDEX
        • CURRENT_NODE_VALUES
        • DS.SERIES
      • Node Properties
        • Node Properties Explanation
    • Global Settings
  • Plan
    • Create New Plan
    • Time Series Forecasting
    • Allocation Features
      • Goal Seek
      • Distribute
      • Copy to Periods
    • Driver Based Planning
      • Enabling Driver Based Plan
      • Configuring Driver Inputs
      • Bulk Configuration of Drivers
    • Plan Interface
  • Simulate
    • Create a Scenario
    • Perform Simulations
    • Manage Scenarios
    • Simulation Interface
    • Add Notes
    • Compare Scenarios
    • Scenario Analysis by Node
    • Create Initiatives in a Scenario
      • Steps to create initiatives
    • Create your Presentation
    • Understanding the Node Components
  • Report
    • Variance Analysis Report
  • ValQ Premium FAQs
  • Glossary
  • Resources
  • Release Notes
Powered by GitBook
On this page
  • 1. Create Model
  • 2. Model Editor
  • 3. Node Settings
  • 4. Templates
  • 5. Formula Functions
  • 6. Global Settings

Model

Build your business models with ease using ValQ's Model Tab

PreviousThe ValQ WorkflowNextGet Data

Last updated 1 year ago

Model tab is the first tab on ValQ where you can create the structure of your model and configure the node properties for your business-specific use case.

To understand the Model tab, its features have been explained in these major sections:

Let us have an overview of each section.

In the Power BI service, the model tab is available only in the Editing view.

1. Create Model

The first step is to choose how you would like to begin building the ValQ model. We'll look into the three ways to create a new model.

2. Model Editor

Editing a model involves structuring the entire layout of the model and setting up each node using features such as formulas, templates, bulk edit, node settings, display properties, and more.

3. Node Settings

4. Templates

5. Formula Functions

6. Global Settings

While we explore each of the above sections in the upcoming pages, let us first learn to get data into ValQ.

To view the model in the reading view, you can enable this option - 'Enable Model tab in the Reading view' in the menu.

Editing the model requires editing and configuring the node properties such as node name, type, configuration, simulation method, etc. - all of which are available in the window.

While building a model, you can make use of the Template feature whenever you need to create a repetitive node structure. Templates are discussed in detail in .

In this section, you can find information about keywords.

You might need to use the Settings menu on the toolbar for configuring the global level settings of the visual anytime during the ValQ workflow. This is explained separately in the section

Node Settings
this section
Functions and Formula
Global Settings.
Create Model
Model Editor
Node Settings
Templates
Formula Functions
Global Settings
Select Model Tab
Three ways to Create Model
Model Editor
Node Settings window
Settings
Settings