Numeric input with suggestions
A Numeric with Suggestions column is a number field with a shortcut built in: a small suggestion icon opens a list of relevant past values, so a user can pick a plausible number instead of guessing or hunting for it elsewhere.
- Add a custom column and set its Type to Numeric with Suggestions.
- Configure where the suggestions come from:
- Dimension Filter - the Qlik dimension that scopes the history to this row (for example, the row’s product or customer).
- Measure - the Qlik expression that produces each suggested value.
- Value Column Label - the header shown above that value in the suggestions list.
- Bound how much history is offered:
- Date Filter and Months Back (1-24, default 6).
- Page Size (10-100, default 20) and Max Suggestions (10-500, default 100).
- Enable Search (on by default) lets the user filter the list by typing.
- Optionally add Additional Dimensions or Additional Comparison Measures - extra read-only context shown next to each suggestion (for example, the date it’s from, or an average to compare against).
Using it
Section titled “Using it”Select the suggestion icon (💡) next to the cell. A paginated, searchable list opens; selecting a row fills the cell with that value and saves it immediately - there’s no separate confirm step.
Worked example
Section titled “Worked example”A demand planner enters next month’s forecast quantity per SKU on a planning sheet. Instead of guessing, they add a Forecast Quantity column of type Numeric with Suggestions, with Dimension Filter set to Product, Measure set to actual shipped quantity, Months Back set to 6, and an Additional Comparison Measure showing the 3-month average shipped quantity. For SKU “WIDGET-42”, opening Suggestions shows the last six months’ actual shipped quantities (510, 495, 480, 520, 505, 490) next to a 3-month average of 498 - the planner selects last month’s figure of 490 instead of typing an arbitrary number, and the cell saves right away.